Forum Discussion
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...
PPStar , try like
CALCULATE([Monthly measure],TOPN(5,all(Table[Workspace]),[Last year measure],DESC),VALUES(Table[Workspace])))
I dont understand what you have done there. What is [MonthyMeasure]