Blank measure in SSAS will display its value in Power BI?

[Anonymous]

Hi,

This is more like a DAX question:

I have the next measure:

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

When I am in the grid view in SSAS , 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?

[Anonymous]

Hi @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with yours. Thank you.

Best Regards

[Anonymous]

Hi @Anonymous ,

The following links are the threads which have the similar problem with yours, please check it out and hope they can help you solve the problem.

TOTALYTD Returning BLANK

DATESYTD doesn't work

Best Regards

[amitchandak]

@Anonymous , Have you selected any date on the page. Otherwise, it will take the last date of the date table as end date.

Refer why Time intelligence fails -https://youtu.be/OBf0rjpp5Hw

[Anonymous]

I am in SSAS right now, I was looking for a way to test it in SSAS...