question

ArunRaaman-6281 avatar image
0 Votes"
ArunRaaman-6281 asked CarrinWu-MSFT commented

calculated DAX measure (cells) are empty in SSAS Tabular Model

Hello There,

I have been practicing SSAS Tabular Mode tutorial, in the tutorial 06: 'Create Measures', there are some custom measures, which I executed in the empty cells within the measure grid of fact table; but, I see the result is empty.

Would any please help me understand the reason for empty-cell result? Thank you for giving your valuable time.

Here is the link for the source document, where the custom calculations are defined at the end of the document: "https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-6-create-measures?view=asallproducts-allversions"
as-lesson-6-create-measures


sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ArunRaaman-6281, welcome to Microsoft Q&A! Have you complete lesson 1 to lesson 5 successfully? And did you get the same value for step 'To create an InternetDistinctCountSalesOrder measure in the FactInternetSales table'? I done this tutorial before, it seems that there is no error for me.

0 Votes 0 ·

Hi @ArunRaaman-6281, we have not get a reply from you. Please let us know if you need any further help.

0 Votes 0 ·

1 Answer

dgosbell avatar image
0 Votes"
dgosbell answered

I've seen this happen from time to time. Sometimes closing and re-opening SSDT will fix this.

But the measures grid is not a great way to test that your measures are working. I would suggest either using the Open in Excel button from SSDT so that you can test your measures in an Excel pivot table. Or maybe using something like the Query Builder in DAX Studio https://daxstudio.org (which is a tool I built)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.