RankX practice model

[ElizabethTachjian]

Hi,

Can you suggest videos and practice model I can watch and practice on to learn advance Rankx function. Including ordering, ties and dense. I have quite a few duplicated values in the rankx column and also need the RANKx values to change as the slicer selection changes. RankX column can have duplicated rank but not skip rank numbers. For example 1, 2,2,2 ,3,4,5,6 (not 1,3,4). Also wanting to use a variable. thank you inadvance.

[BrianJ]

@ElizabethTachjian ,

Here are two videos, one by me and one by @AntrikshSharma that should fit the bill for you. We take different approaches so you’ve got some options in how you handle this problem:

Developing Custom Tiebreakers in RANKX - DAX Tutorial

Breaking Ties in RANKX using COUNTROWS + FILTER | Power BI DAX

I hope this is helpful.

– Brian

[Rajesh]

Hi @ElizabethTachjian

Here is another approach to break RANKX ties. I hope this is also helpful to you.

Break RANKX Ties

Hi All, There are n number of ways to break ties. I just wanted to share with you this approach. [image] First I created Rank using SKIP, [image] To break the ties created sub rank by total. [image] Finally combined these two ranks. [image] Here is the DAX measure. [image] Rank Ties.pbix (18.0 KB) I hope this is helpful.

[ElizabethTachjian]

Thank you for coming to the rescue. I look forward to the learning the Rankx function. Cheers E