Forum Discussion

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
3 years ago

DAX Help. Rank or Filter

Hi, i have the following Measures   Usage - Consumer = var consumer = CALCULATE('Measures'[Usage - All], Activities[Role] = "Consumer") Return IF(ISBLANK(consumer),"0",consumer)   The UsageAll...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

PPStar , try like

 

CALCULATE([Monthly measure],TOPN(5,all(Table[Workspace]),[Last year measure],DESC),VALUES(Table[Workspace])))

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
3 years ago

I dont understand what you have done there.  What is [MonthyMeasure]