Forum Discussion
sizi
Helper II
Helper IIDAX to define Overall rank based on 2different Ranks
Hello All, I need to define rank for each employee based on average of 2 defined ranks. Below is the original data: Employee TaskRank SLA Avg(Task+SLA) John 2 3 2.5 claire 4 ...
Hi sizi ,
Try the following expression:
Rank = var _t = ADDCOLUMNS('Table',"Rank",RANKX(ALL('Table'),[AVG],,ASC,Dense))
RETURN MAXX(_t,[Rank])
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
siziHelper II
Helper IIIt isnt working for me. Task rank, sla rank is all measure defined from measures. I dont know the dax doesnt work for me 😞