Forum Discussion
Helper IRanking 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 to the visual the ranking list all 1's. Any help would be greatly appreciated.
Data Sources / Relationships
Employee Report 1:M Survey Data
Measure
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
3 Replies
- mahoneypat
Microsoft Employee
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
jake223Thank 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
