Forum Discussion

jake223's avatar
jake223
Helper I
5 years ago
Solved

Ranking Data

Hello,   I'm fairly new to PowerBi and having an issue ranking within a table visual. When I have two columns in the visual the ranking works as expected the issue is when I add additional columns ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    The Name column is also filtering the data (so you end up with 1s). You need to include that column too in your ALLSELECTED.

     

    Rank Average = RANKX(ALLSELECTED('Employee Report'[EENo], 'Employee Report'[Name]), [Final_Total Average],,DESC)

     

    Regards,

    Pat

     

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi jake223 

you can do it like this:

 

 With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)