Forum Discussion
Solved
Rank
Employee Name, Performance Score%, Total Volume of Work, Rank A 100% 600 2 B 50% 800 4 C 100% 900 1 D 100% 200 3 I have only Table of Team List where employee n...
Hi aqsyed
I create an 'Employee' table with the same data sample, then created a new column 'Rank' using the below DAX code
Rank=
RANKX(ALL(Employee),
RANKX(ALL(Employee),Employee[Performance Score%],,ASC,Dense) & "" & RANKX(ALL(Employee),Employee[Total Volume of Work],,ASC,Dense)
,,DESC,Dense)Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
Hi aqsyed
I create an 'Employee' table with the same data sample, then created a new column 'Rank' using the below DAX code
Rank=
RANKX(ALL(Employee),
RANKX(ALL(Employee),Employee[Performance Score%],,ASC,Dense) & "" & RANKX(ALL(Employee),Employee[Total Volume of Work],,ASC,Dense)
,,DESC,Dense)
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge