Forum Discussion
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 name and Id is mentioned.
total volume of work is calculated with measure = SALES1+ SALES 2+ SALES 3
Performance Score with measure = Quality Score + Time Score +
Total Volume of Work Score. I Want to calculate rank as mentioned above on the basis of performance score. If the performance score is same then check the total volume of those employees who has done the highest volume of work give the rank.
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
1 Reply
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