• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Removing filter context from a RANKX measure

redroller

New Member
This must be basic, but I can't get it working. I have the following measure to rank employees in an index table, based on a measure to count scores in another table. It works correctly if I use it in a matrix with the employee name in rows (EmployeeTeams[Employee]).

However, when I incorporate the matrix into an existing dashboard with page-level filters, it returns the same rank value for all employees. How do I modify the syntax to ignore all page level filters? Thank you.

RANK Employee =
RANKX(ALL(EmployeeTeams[Employee]),
CALCULATE([Score Count]),
,
DESC
)
 
Top