Hi guys,

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[Calls])),DESC), RANKX(ALL(Sheet2),

CALCULATE(SUM(Sheet2[Total Handle Time] )),ASC),

DESC, Dense)

I have attached my sample. Any help and advice, i would really appreciate.

Rankx_Sample.pbix (32.7 KB)

Many thanks,

erika