Break RANKX Ties

DAX DAX Calculations
1

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
image1313Ă—443 39.3 KB

Rank Ties.pbix (18.0 KB)

I hope this is helpful.

4 Likes
2

Thanks for the information @Rajesh! We appreciate users sharing varied updates and infos relevant to Power BI.

We are tagging this post as “Solved” due to the inactivity if the thread. For further questions related to this post, please make a new thread.