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
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 🙂