Forum Discussion

Prahlad's avatar
Prahlad
Frequent Visitor
2 years ago
Solved

Dynamic Ranking with slicers without summation of values

I have a Table in excel by the name "Compiled" which I have loaded in Power BI. It has the following columns: Month Segment SUPPLIER CODE SUPPLIER NAME DOMAIN Overall Score (Rounded Off) ...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    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:

     

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi Prahlad,

I'm attaching a pbix file with my solution.

Please take a look and see if this could solve your issue.

  • Prahlad's avatar
    Prahlad
    Frequent Visitor
    2 years ago

    Hi _AAndrade . Thanks for replying. I however have Power Bi desktop version of 2021 and I'm unable to open files of newer versions. Could you please send me what changes have you done exactly or the code?