Forum Discussion

krzysztof's avatar
krzysztof
Icon for Helper III rankHelper III
6 years ago
Solved

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] ))