Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Exclude Users from Ranking RANKX

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 ...
DAX
exclude
exclusions
RANKX
users
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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:]
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

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:]
    )
)