Forum Discussion
Solved
Unexpected Ranking Behavior When Adding Dimensions in Power BI
I was working with the RANK function to rank sales by Sub-Category, and it works fine when only Sub-Category is in the table. However, when I add another dimension (like a different field), the ranki...
Hi,
Thank you for your message, and in my opinion, please try to write the measures like the attached file.
Thanks , this really helps. The issue was never the Rankx but the underlying measure .
[Total Saless All Except Sub-Cat With Slicer]=CALCULATE([Total Sales], ALLSELECTED(Orders),VALUES(Orders[Sub-Category]))
Once I changed that , RankX worked like a charm without need to summarizeSub-Category Ranking =
RANKX( ALLSELECTED ( Orders[Sub-Category]), [Total Saless All Except Sub-Cat With Slicer],,,Dense)
anshusaketsingh , can also include region in Rankx and Try
Sub-Category Ranking =
RANKX(ALLSELECTED(Orders[Sub-Category],Orders[Region]),[Total Saless All Except Sub-Cat With Slicer],,,DENSE)
Your formula didn't work. Even if it did, it would make the ranking inconsistent, especially when another region dim is added to the table as region as dimension shouldn't impact ranking.