Forum Discussion

jp123's avatar
jp123
Frequent Visitor
5 years ago
Solved

RANKX using a measure based on multiple categories

Hello,   I'm trying to generate a rank of a measure [Average Gross Profit], based on several columns.    Columns:      data[Model], data[colour], data[Year]   [Average Gross Profit] is the comb...
General Comment
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this measure

    Rank = RANKX(ALL(data),[Average Gross Profit])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this measure

Rank = RANKX(ALL(data),[Average Gross Profit])

Hope this helps.

jp123's avatar
jp123
Frequent Visitor
5 years ago

Thanks, Ashish. Much appreciated.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.  If my previous reply helped, please mark that as Answer.