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 |