topic Re: Ranking by KPIS in DAX Commands and Tips

Ranking by KPIS

Anonymous — Thu, 14 Jul 2022 18:30:56 GMT

Hi folks!

I need to ranking my sellers using 5 KPIS x target, its possible using IF and RANK?

Ex:

Target KPI A = 95%
Target KPI B = 80%

Seller 1 -
KPI A = 90%
KPI B = 80%

Seller 2 -
KPI A = 100%
KPI B = 80%

-
MONTH RANK
1º -Seller 2
2º Seller 1

Rgdrs,

amitchandak — Fri, 15 Jul 2022 03:16:39 GMT

Anonymous , see if this can help

You can have like

Switch(selectedvalue([KPI])

"KPI1", Rankx(allselected(Table[seller]), [KP1],

"KPI2", Rankx(allselected(Table[seller]), [KP2],

"KPI3", Rankx(allselected(Table[seller]), [KP3],

"KPI4", Rankx(allselected(Table[seller]), [KP4],

"KPI5", Rankx(allselected(Table[seller]), [KP5] )

Anonymous — Tue, 19 Jul 2022 09:34:56 GMT

Hi Anonymous ,

I created some data:

Here are the steps you can follow：

1. Select two columns – Unpivot Columns.

2. Create calculated column.

Index = IF( 'Table'[Value]>='Table'[Target], RANKX( FILTER(ALL('Table'), 'Table'[KPI]=EARLIER('Table'[KPI])),[Value],,DESC),0)

3. Create measure.

Rank = SUMX( FILTER(ALL('Table'), 'Table'[Attribute]=MAX('Table'[Attribute])),[Index])

4. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

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

Anonymous — Wed, 27 Jul 2022 17:58:17 GMT

Thnx a lot!!! Sorry bout delay!