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

mq 1 Reputation point
2021-03-22T09:45:16.59+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,004 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alexei Stoyanovsky 3,321 Reputation points
    2021-03-23T07:09:11.16+00:00

    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.

    No comments

  2. Lukas Yu -MSFT 5,796 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 :
    80547-image.png