Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
12 |