Forum Discussion
Dynamic Ranking with slicers without summation of values
I used another two DAX measures:
MAX(f_Data[Overall Score (Rounded Off)]) Rank Score base on Max = RANKX( ALLSELECTED(f_Data[DOMAIN],f_Data[SUPPLIER NAME], f_Data[Segment], f_Data[SUPPLIER CODE]), [MAX Score], ,DESC )The final output was this:
Resident RockstarHi Prahlad,
I used the data that you provided and used these DAX formulas:
Total Score = SUM(f_Data[Overall Score (Rounded Off)])
Rank Score =
RANKX(
ALLSELECTED(f_Data[DOMAIN],f_Data[SUPPLIER NAME], f_Data[Segment]),
[Total Score],
,DESC
)
Final Results:
Thank you _AAndrade for the reply.
Here is what I've got as output.
The thing is, the values of "Overall Score (Rounded Off)" does not exceed 500 in the excel file. And the total score shown here is more than 500. I feel the ranking is based on the sum of values in "Overall Score (Rounded Off)" and not individual values. Could you please provide a code that Ranks based on the individual values in "Overall Score (Rounded Off)"?
Also, the excel file data has duplicate Values in "Supplier Name" since this is like performance data for months Nov-Apr.
Please find below, the complete table. I have removed the "Supplier Name" Column since that data is slightly confidential, if that's alright.
| Month | Segment | SUPPLIER CODE | DOMAIN | Overall Score (Rounded Off) |
| Nov`23 | MHCV | 7200980 | NON-METALLIC | 450 |
| Nov`23 | MHCV | 7204096 | NON-METALLIC | 340 |
| Nov`23 | MHCV | 7203771 | CHASSIS PROP | 425 |
| Nov`23 | LCV | 7205672 | CHASSIS PROP | 383 |
| Nov`23 | MHCV | 7200370 | CHASSIS PROP | 300 |
| Nov`23 | MHCV | 7205371 | CHASSIS PROP | 340 |
| Dec`23 | MHCV | 7200002 | BAR MACHINING | 375 |
| Dec`23 | MHCV | 7200004 | NON-METALLIC | 407 |
| Dec`23 | MHCV | 7200013 | ENGINE PROP | 450 |
| Dec`23 | E-H1,MHCV | 7200015 | FORGING | 375 |
| Dec`23 | E-H1,MHCV | 7200016 | CASTING | 275 |
| Dec`23 | MHCV | 7200017 | ELECTRICAL | 425 |
| Jan`24 | MHCV | 7200002 | BAR MACHINING | 343 |
| Jan`24 | MHCV | 7200004 | NON-METALLIC | 408 |
| Jan`24 | MHCV | 7200013 | ENGINE PROP | 500 |
| Jan`24 | E-H1,MHCV | 7200015 | FORGING | 350 |
| Jan`24 | E-H1,MHCV | 7200016 | CASTING | 347 |
| Jan`24 | MHCV | 7200017 | ELECTRICAL | 412 |
| Jan`24 | MHCV | 7200019 | ELECTRICAL | 275 |
| Feb`24 | MHCV | 7200002 | BAR MACHINING | 369 |
| Feb`24 | MHCV | 7200004 | NON-METALLIC | 409 |
| Feb`24 | MHCV | 7200013 | ENGINE PROP | 500 |
| Feb`24 | E-H1,MHCV | 7200015 | FORGING | 375 |
| Feb`24 | E-H1,MHCV | 7200016 | CASTING | 337 |
| Feb`24 | MHCV | 7200017 | ELECTRICAL | 455 |
| Feb`24 | MHCV | 7200019 | ELECTRICAL | 300 |
| Feb`24 | E-H1,MHCV | 7200021 | CHASSIS PROP | 475 |
| Mar`24 | MHCV | 7200946 | RM | 375 |
| Mar`24 | MHCV | 7200004 | NON-METALLIC | 409 |
| Mar`24 | MHCV | 7200013 | ENGINE PROP | 500 |
| Mar`24 | E-H1,MHCV | 7200015 | FORGING | 375 |
| Mar`24 | E-H1,MHCV | 7200016 | CASTING | 337 |
| Mar`24 | MHCV | 7200017 | ELECTRICAL | 455 |
| Mar`24 | MHCV | 7200019 | ELECTRICAL | 300 |
| Mar`24 | E-H1,MHCV | 7200021 | CHASSIS PROP | 475 |
| Apr`24 | MHCV | 7200002 | BAR MACHINING | 322 |
| Apr`24 | MHCV | 7200004 | NON-METALLIC | 410 |
| Apr`24 | MHCV | 7200010 | CASTING | 475 |
| Apr`24 | MHCV | 7200013 | ENGINE PROP | 500 |
| Apr`24 | E-H1,MHCV | 7200015 | FORGING | 400 |
| Apr`24 | E-H1,MHCV | 7200016 | CASTING | 336 |
| Apr`24 | MHCV | 7200017 | ELECTRICAL | 455 |
| Apr`24 | MHCV | 7200019 | ELECTRICAL | 300 |
| Apr`24 | E-H1,MHCV | 7200021 | CHASSIS PROP | 475 |
| Apr`24 | E-H1,LCV,MHCV | 7200023 | NON-METALLIC | 360 |
- _AAndrade
I used another two DAX measures:
MAX(f_Data[Overall Score (Rounded Off)]) Rank Score base on Max = RANKX( ALLSELECTED(f_Data[DOMAIN],f_Data[SUPPLIER NAME], f_Data[Segment], f_Data[SUPPLIER CODE]), [MAX Score], ,DESC )The final output was this:
It worked! Thanks alot