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.
Hi,
I am trying to calculate rank on the table visual that has multiple slicers on it. When the table has 1 column, rank appears correctly (pic 1). However, when I start adding another column to the table (the second column adding is just a description of the first column so it's 1 to 1), ranking is not correct anymore (like pic 2). What I want is to have pic 2 have correct rank like pic 1.
Any help/tips are appreciated. thank you
Good ol' RANKX...
Getting a hold of why RANKX is doing this is complicated and involves some knowledge of row contexts, which is a core principle of the DAX language.
This does a pretty good job explaining it:
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/
The short answer is that you need to ignore ALL of the fields in your visual to get RANKX to return the right value. Add them to your ALL() statement, and it should work.
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |