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 ,
If you want to use measure, try it:
Measure = var _t = ADDCOLUMNS('Table',"Rank",RANKX(ALL('Table'),'Table'[Avg(Task+SLA)],,ASC,Dense))
RETURN MAXX(_t,[Rank])
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 IIall the 3 columns are measures defined fyi.