Forum Discussion
Sort by Column does not change sorting order
How are the two tables related?
1) Create a FirstName Rank Column in the Table containing FirstName
This Column should Rank DESC based on the Line Total from the other Table
2) Sort FirstName by this new Column
3) then Filter TOPN - show Bottom 5 - by value - sum of FirstName Rank
Hope this helps! :smileyhappy:
They're related through my data model. The relation works properly in my report, there should not be an issue.
I think what's happening here is that I'm essentially using the sorting correctly, but PBI doesn't understand how to sort the sums correctly. I haven't tried creating a proper TOP N style column for this I did create a simple manual type of rank where I gave values to the employees from "1 to 5". Sorting that worked as expected.