Forum Discussion
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 error using Dense:
Results:
Expected Ressult:
Thanks so much in advance!
Hi Anonymous
Syntax error. You need to have thee commas before "Dense" not only one. However, this won't help to break the ties. There must be other columns that can be used to break the tie but simplist method is to create an index column using power query then your ranking formula would be
Rtotal =
RANKX (
CALCULATETABLE (
PO_PurchaseOrderDetail,
ALLEXCEPT ( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] )
),
PO_PurchaseOrderDetail[Index],
,
asc,
DENSE
)
2 Replies
Hi Anonymous
Syntax error. You need to have thee commas before "Dense" not only one. However, this won't help to break the ties. There must be other columns that can be used to break the tie but simplist method is to create an index column using power query then your ranking formula would be
Rtotal =
RANKX (
CALCULATETABLE (
PO_PurchaseOrderDetail,
ALLEXCEPT ( PO_PurchaseOrderDetail, PO_PurchaseOrderDetail[ItemCode] )
),
PO_PurchaseOrderDetail[Index],
,
asc,
DENSE
)