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 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!
