Intermediate Power BI - How to rank using RankX

RankX in PowerBI can be tricky. It's very particular to the context of the table and any slicing function. Additionally, defining expressions will also require fine-tuning.
RankX: returns the ranking of a number in a list of numbers for each row in the table argument.
Documentation: docs.microsoft.com/en-us/dax/...

[@DarkoVlajkovic]

perfectly explained with errors that could come up, thank you so much :)

[@MrVargs120]

Great job of explaining how RANKX works. Thank you!!!🔥🔥🔥

[@AinNo1GonDoYou]

straight to the point thank you! I finally got my rankx working

[@VarunKumar-xt4jq]

You made my day.....saved a lot of time....

[@johnylingo4673]

amazing!! thank you! straightforward, quick explanation!

[@nehaahmed46]

Seen many videos but thanks to you that my rankx works. :)

[@wllymchng]

Awesome!

[@abrahamgarcia6818]

you REALLY HELPED ME, a Lot of Peopple didn't explain about doing a duplicate by callyng Totals; THANK YOU

[@nikolagrkovic8769]

THANK YOU THANK YOU THANK YOU, AFTER 2 MONTHS, FINALLY

[@anthonynorman1212]

Keep Making those Videos, the fact that your purposefully make the mistakes helps me feel that you are more of a human and than an elite robots. I do have a question, hopefully you can help me out here. The point of my table is to illustrate which of our employees rank highest with their absenteeism over the last 12 months and any tie break requires the previous 12 months. I have have calculated both the last 12 months absenteeism and the previous 12 months absenteeism, how can i filtre the rank so that it shows the ranking as position 1,2,3,4,5 to 20 without duplicates or grouping?

[@608er]

Great explanation 👏🏻

[@bhakthasingh8198]

Excellent!

[@sum1257]

Thanks a lot! Was really helpful

[@magdalenasokolova9073]

can you please make it work with all selected but with the 2 columns of string values not just one?

[@mardithpascua8112]

do you have a workaround? ill be needing a rank per Category in my table Matrix, but currently I am having hard time , per category there are different ranks

[@renecernitz4786]

I'm trying to rank the count (frequency) of a TEXT column but It doesn't work. Raw table column (text type) A C C C C B B I want to rank the frecuency of them Desired result Letter | Frequency | Ranking A | 1 | 3 B | 2 | 2 C | 4 | 1 Thanks in advance for your advice

[@shreyoshiraychaudhary8808]

Hi, why is the ranking not proper when using All('Table')?

[@praveen26699]

Thank you so much❤

[@wllymchng]

Thanks man

[@mrkraymnd]

What’s the benefit of rank in this case rather than just sorting the value largest>smallest

[@wllymchng]

If I'm understanding your question correctly - it really just depends on how you want to tell your story visually. There is no right/wrong way of displaying; it just depends on what you're trying to say. In some situations, using the table's native sort feature might not suffice for what you need. In which case, you may need to rely on a Measure. An example of why you would need a Measure vs just sorting the table would be: maybe your BI manager or Director simply wants to see a rank value (1,2,3...etc) next to the data categories, even though when sorting on a small table it is clear who 1,2,3 is.

[@wonderfulvazquez7957]

If I wanted to create a measure for percent of the total ranking...for example when you have categories a,b,c,d and they are ranked 1,2,3,4 respectively..my goal is to see 25%, 50%,75%, 100% respectively.

[@echezonaazubike8054]

God Bless you

[@sahilmittal1382]

Best resolution found