Forum Discussion
RANKX DUPLICATED
I've been tired of a couple of hours of duplicates in rankx.
I want to make a ranking after the stores. If someone chooses a store manager, then column "Rankx store all" should ignore the manager's choice and show the ranking of stores on total
Where the ranking shows duplicate data, the values are different
Ranking distri =
CALCULATE (
IF (
HASONEVALUE ( DimLocalization[StoreID] );
RANKX ( ALLSELECTED ( DimLocalization[StoreID] ); [W.Sp AC];; DESC )
);
ALL ( DimLocalization[District] ))
Hi krzysztof
Data is too scarce to repro your issue, but I believe you can refer to these similar posts:
https://community.powerbi.com/t5/Desktop/Rank-values-without-duplicate-ranking/m-p/702224
https://community.powerbi.com/t5/Desktop/Rank-distinct-values-for-ties/td-p/194301
2 Replies
- amitchandak
Super User
Use dense option and refer how to break ties
https://community.powerbi.com/t5/Desktop/Rank-distinct-values-for-ties/td-p/194301
- v-diye-msft
Community Support
Hi krzysztof
Data is too scarce to repro your issue, but I believe you can refer to these similar posts:
https://community.powerbi.com/t5/Desktop/Rank-values-without-duplicate-ranking/m-p/702224
https://community.powerbi.com/t5/Desktop/Rank-distinct-values-for-ties/td-p/194301