Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi Anonymous,

I'm attaching a pbix file with my solution.

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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?