Forum Discussion
Custom list sorting for duplicate values
Think how you might do this in real life: You would GROUP BY the ID column and take the MIN of the Rating column, or whatever aggregation gets you A values instead of B. Create a DAX (or Power Query) table that does that aggregation.
If you sort your distint list of Ratings, the list would be, in alphabetical order, A, B, D, Fail, Pass (because the F in Fail comess before the P in Pass). If you want Pass to come before Fail, then you should probably convert the letters to numbers: A=1, B=2, C=3, Pass=4, Fail=5, and get the MIN of the number.
Thanks for this guidance - it's helpful to have someone simply explain to my what I'm trying to do in terms that I can apply to PowerBI! I had hit a wall and had no one to speak with, but the way you've described this is really useful.