RANKX Problem

[krzysztof]

I have a problem with the Rankx all stores & RKS column.
I want it to show the ranking of a given store within all RKS.
To sum up: the Rankx all stores column shows a dynamic ranking depending on which country and RKS you choose - it works properly.

The Rankx all stores & RKS column should show a dynamic ranking depending on which country you choose, but it should not work with the RKS filter - it should show a total ranking in all RKS.

Code column rankx all stores & RKS:

Rankx all stores & RKS = RANKX(
ALL(DimLocalization[RKS];DimLocalization[StoreID]);
CALCULATE(SUM(FactSales[Revenue_Net]))

[amitchandak]

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[krzysztof]

@amitchandak Unfortunately, I have an exposed cube and can't create columns

[amitchandak]

I think I did not suggest any column. All these articles talk about various kinds of ranks. Can you please create some sample data and share with expected output

[kentyler]

This sounds like a place for ALLEXCEPT()

CALCULATE(SUM(FactSales[Revenue_Net]))

CALCULATE(SUM(FactSales[REvenue_Net]),ALLEXCEPT(RKS))