Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
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
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
This sounds like a place for ALLEXCEPT()
CALCULATE(SUM(FactSales[Revenue_Net]))
CALCULATE(SUM(FactSales[REvenue_Net]),ALLEXCEPT(RKS))
Help when you know. Ask when you don't!
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |