How to write a rank measure?

[YunJ]

Hi,

I would like to add a rank in this table based on the GMV, I tried the measure as the following, but failed...

Thanks for your help!

[v-diye-msft · Accepted solution]

Hi @YunJ 

Let me know if you'd like to get this one?

Measure = CALCULATE(SUM('2020'[GMV]),FILTER('2020','2020'[Category_flag]="Category-L1"))

Brand store GMV_Rank = RANKX(ALLSELECTED('Raw Data'[Brand]),[Measure],,DESC)

Pbix attached.

[amitchandak]

@YunJ ,For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[YunJ]

Hi @amitchandak @Greg_Deckler 

I tried to write measure but failed.. Could you kindly download the pbix file in my previous reply?

Thanks

[Greg_Deckler]

That link does not appear trustworthy to me as it does not go to dropbox as it says it does. It actually links to here:

https://wx.qq.com/cgi-bin/mmwebwx-bin/webwxcheckurl?requrl=https%3A%2F%2Fwww.dropbox.com%2Fs%2Fi1lf4...

And it does not work.

[Greg_Deckler]

I have numerous examples here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

As well as alternatives to RANKX