Forum Discussion
jp123
5 years agoFrequent Visitor
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
- Ashish_Mathur
Super User
Hi,
Try this measure
Rank = RANKX(ALL(data),[Average Gross Profit])Hope this helps.
- jp123Frequent Visitor
Thanks, Ashish. Much appreciated.
- Ashish_Mathur
Super User
You are welcome. If my previous reply helped, please mark that as Answer.