RANKX using a measure based on multiple categories

[jp123]

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!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[jp123]

Thanks, Ashish. Much appreciated.

[Ashish_Mathur]

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