Breaking Ties in Rankings with RANKX Using Multiple Columns
There are situations in which you want to use a ranking of rows based on one column, but that column has non-unique values. Sometimes, there are other columns you want to use, if two rows have the same value in the primary ranking column. In this blog, I want to explain step by step how ranking based on multiple columns (more than 2!) can help you solve this problem in DAX. The pattern used is something I picked up in this community, the focus in this blog is on the inner workings of that pattern.Power BI – Handling Duplicate Rankings Using the RANKX DAX Function
Power BI supports a functional language called DAX (Data Analysis Expressions), which basically represents an executable piece of code inside a function. DAX expressions can sometimes be difficult to use and understand. There are multiple DAX expressions out there, but today I will be concentrating on a problem statement for using the RANKX function, and how to resolve it.
