Forum Discussion
Create rank under each LOB and under their supervisor
I have date table & main file which has supervisor, agent id, lob for each employee, I have aes file where I was calculating the aes attainment, (aes num/aes denom) which is a measure I have QA fil...
Ammulu_M , Create a measure using DAX
Employee_Rank =
RANKX(
ALLSELECTED('Main File'[EmployeeID]),
CALCULATE([Overall_Attainment], ALLEXCEPT('Main File', 'Main File'[LOB], 'Main File'[Supervisor], 'Date'[Date])),
,
DESC,
DENSE
)