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.
RankX Ranking Ties
Hello, Can someone help with how to break ties? I have the below dax forumla creating a ranking column in my table using item code that thens ranks by the earliest date. I tried adding dense to the ties portion of the formula and I get this error Ranking = VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE]) Ranking error using Dense: Rtotal = VAR __po = PO_PurchaseOrderDetail[PurchaseOrderNo] VAR __cd = PO_PurchaseOrderDetail[ItemCode] RETURN RANKX( FILTER( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] = __cd ),PO_PurchaseOrderDetail[PODATE], DENSE) Results: Expected Ressult: Thanks so much in advance!
