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' (meas...
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