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