question

mq-7327 avatar image
0 Votes"
mq-7327 asked LukasYu-msft commented

In grid view, measure displaying Revenue YearToDate: (blank)

I am in SSAS tabular and I have the next measure:

 Revenue YearToDate:=
 CALCULATE( [Revenue] , DATESYTD( 'Date'[Date] , "31/05" ) )

When I am in the grid view, I click the measure and I see

Revenue YearToDate: (blank)


Is it showing blank because the measure will only display its value when used in ie PowerBI or is it that there is an issue with the measure itself? how can I test if it works?

sql-server-analysis-services
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.

AlexeiStoyanovsky avatar image
0 Votes"
AlexeiStoyanovsky answered

In the grid view, the measure calculates as the grand total of the model, without any filtering. So the most benign reason for the blank is that there's no revenue for the last fiscal year that your 'Date'[Date] column covers. The easiest way to test it is to slice it by some calendar fields in a report alongside the [Revenue] measure.

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.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Have you processed your model or have your process null on the model.

If not , you could process the model see if any results get out and replace the "blank".


Is it showing blank because the measure will only display its value when used in ie PowerBI or is it that there is an issue with the measure itself? how can I test if it works?


No, it would give you same value, if all things went well. It is not only working in PBI. For example :
80547-image.png



image.png (4.6 KiB)
· 1
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.

Have you tried to process the project ? Did you get any update ?

0 Votes 0 ·