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.
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?
2 answers
Sort by: Most helpful
-
-
Lukas Yu -MSFT 5,816 Reputation points
2021-03-23T07:41:37.563+00:00 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 :