Solved: Exclude Users from Ranking RANKX

Anonymous · ‎10-13-2022

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?

Entry Rank = IF(SELECTEDVALUE (System_Users[Account]) IN {"cbelcher","pkessell","kcole"}, "-",

RANKX(ALL(System_Users),Audit[Sum Entry])

)

Many thanks in advance!

Jihwan_Kim · ‎10-13-2022

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.

Click here to visit my LinkedIn page

View solution in original post

Anonymous · ‎10-13-2022

That was perfecft! Thank you very much!

Jihwan_Kim · ‎10-13-2022

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.

Click here to visit my LinkedIn page