Forum Discussion
Solved
Rank dynamically
Hi, I have data with multiple groups. I want to rank them within each group. For example: Product category Product Sales volume Rank Machinery A 50 3 Machinery B 320 1 Ma...
CarlsBerg999
Can you try the following measure?RNK = RANKX( ALLEXCEPT(Table1,Table1[Product category]), CALCULATE(SUM(Table1[Sales volume])) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
CarlsBerg999 You can try something like in this blog post. For your sample data, replace [Category] with [Product Category] and [Sub Category] with [Product]:
RANKX (
FILTER(
ALL(
'Table'[Category],
'Table'[Sub Category]
),
'Table'[Category] = MAX('Table'[Category])
),
CALCULATE(SUM('Table'[My Value]))
)
This returns a ranking of "1" to all rows for some reason.
