Hope maybe someone could help me a bit. I am trying to Rank agent based on two indicators: So the most Calls taken, but the least Total Handle time. I was trying sorting but that didnt work either. So i thought Rankx could maybe work. Here is the closest I got to get the result, but it doesnt seem correct either.
Ranking 2 = RANKX(ALL(Sheet2[Agent Name]),RANKX(ALL(Sheet2),
CALCULATE(SUM(Sheet2[Total Handle Time] )),ASC),
I have attached my sample. Any help and advice, i would really appreciate.
Rankx_Sample.pbix (32.7 KB)