DAX RankX with Ties


  • Hi

    I am looking for example with RankX ties option but did not found that great on internet. Can anyone came across such example?

    Monday, June 11, 2018 7:35 PM

All replies

  • Hi Arnav1210,

    Thanks for your question.

    The values that can be passed for this parameter ties are DENSE and skip, Dense means no gaps in the numeric ranking sequence, and SKIP, which will add gaps. See below calculated column called RankWithTies and RankWithoutTies for better understanding:

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    • Proposed as answer by alexander fun Tuesday, June 12, 2018 10:48 AM
    Tuesday, June 12, 2018 5:31 AM