Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank on a Measure

Hello,

 

I am trying to rank a table based on a measure field. 

 

In my table I have 'Region' (North, South, East, West), 'Today's Sales', 'Today's Sales Target', and '% of target achieved' (measure field).

 

I want to rank on the '% of target achieved' but I can't work out how.

 

Please help :)

 

Thanks!

 

 

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  Anonymous  ,

     

    If you need to create a measure but not a calculated column for Rank, you can use the DAX below.


    Rank = RANKX(FILTER(ALLSELECTED(Table1),Table1[Region]=MAX(Table1[Region])),Table1[% of target achieved],,ASC)

     

    Best regards
    Amy