Forum Discussion

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

How to write a rank measure?

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!
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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.

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

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.