cancel
Showing results for
Did you mean:
Highlighted
New Member

## Rankx to measure performance

So I am trying to use Rankx to measure performance of agents. However each KPI has it's own goal.

 Quallity <= .90 AHT >= 10 Wrap >= 2 CSAT <= .80

Example Current formula

Ranking  =
RANKX (
ALL ( 'Roster' ),
RANKX ( ALL ( 'Roster'), [QA], ,ASC )
+ DIVIDE (
RANKX ( ALL ( 'Roster'), [AHT (Call)] , ,DESC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 1 )
+ DIVIDE (
RANKX ( ALL ( 'Roster' ), [Avg. Wrap] , ,DESC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 2 )
+ DIVIDE (
RANKX ( ALL ( 'Roster'), [CSAT offered] , ,ASC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 3 )
)
)))

1 ACCEPTED SOLUTION

Accepted Solutions Community Support

## Re: Rankx to measure performance

Hi @CASTI ,

I think your formula is fine and you just need to increase the proportion of each row like below.

``````rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*100000
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*1000
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*10
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d`````` And if your proportion for each row is low the result would be effected.

``````rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*4
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*3
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*2
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d`````` Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2 Super User I

## Re: Rankx to measure performance

Hi @CASTI ,

When you are trying to get Rank based on 4 different criteria. I would recommend a weightage to be given to each criteria.  Then using the achievement in each criteria arrive at the weightage for the criteria.  Sum up the weightage of criteria. Then rank based on the sum weihtage.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut! Community Support

## Re: Rankx to measure performance

Hi @CASTI ,

I think your formula is fine and you just need to increase the proportion of each row like below.

``````rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*100000
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*1000
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*10
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d`````` And if your proportion for each row is low the result would be effected.

``````rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*4
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*3
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*2
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d`````` Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements #### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section. #### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products. Top Solution Authors
Top Kudoed Authors
Users online (2,042)