Forum Discussion
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 ...
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
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
Thank you mahoneypat
can't believe I missed that, I updated my measure and it worked.
RANKX(ALLSELECTED('Employee Data'), [Final_Total Average],,DESC)Followup question:I'm also looking for a second ranking measure to be the overall rank and not change when filters are applied, any idea how I could do that?Example:EENo Name Average Filter Rank Overall Rank
1 John 1.1 1 1
2 Steve 1.0 2 2
3 Emily .2 3 3
