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.
Jolly Day,
I am needing to exclude three users from being included in the ranking. What I currently have just inserts a dash where there ranking number would be and are still being ranked. Could someone help me with a measure to completely exclude them?
Many thanks in advance!
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Expected rank measure: =
IF (
SELECTEDVALUE ( System_Users[Account] ) IN { "A001", "A002", "A003" },
"-",
RANKX (
FILTER (
ALL ( System_Users ),
NOT ( System_Users[Account] IN { "A001", "A002", "A003" } )
),
[Value measure:]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
That was perfecft! Thank you very much!
Hi,
I tried to create a sample pbix file like below.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Expected rank measure: =
IF (
SELECTEDVALUE ( System_Users[Account] ) IN { "A001", "A002", "A003" },
"-",
RANKX (
FILTER (
ALL ( System_Users ),
NOT ( System_Users[Account] IN { "A001", "A002", "A003" } )
),
[Value measure:]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |