Ranking based on multiple values

DAX DAX Calculations
4

Hi @Jetuke_ES,

Play around with this.
Here the number of calls counts for 1, the avg time for 2 divide the result by 3, to rank that.

Ranking with weight factor = 
VAR RankWeight =
    RANKX(
    ALLSELECTED(Sheet2[Agent Name]), 
    DIVIDE(
        RANKX(
            ALLSELECTED(Sheet2[Agent Name]), 
            CALCULATE(SUM(Sheet2[Calls])), , DESC, Dense) +
        RANKX(
            ALLSELECTED(Sheet2[Agent Name]), 
            DIVIDE(CALCULATE(SUM(Sheet2[Total Handle Time])), CALCULATE(SUM(Sheet2[Calls]))), , ASC, Dense) *2
        , 3
    ), , ASC, Dense)
RETURN

    RankWeight
1 Like