Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |