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 combined average of severage units per category.

 

So the calculations must combine the model, colour and year categories for an overall rank.

 

 

The .pbix document can be accessed via dropbox here: https://www.dropbox.com/s/15rid075oiga48b/Example%20File.pbix?dl=0

 

 Thank you!

  • Hi,

    Try this measure

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

    Hope this helps.

3 Replies

  • Hi,

    Try this measure

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

    Hope this helps.

    • jp123's avatar
      jp123
      Frequent Visitor

      Thanks, Ashish. Much appreciated.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

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