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.

[CavalierNSN]

I couldn't find another source/refence that could help me understand why I couldn't get results using the implicitly defined columns Power BI derived from my Excel Source. It wasn't until I found your video that the struggle between "implicit" and "explicit" references became ultra clear to me. For that, thank you.

[MrVargs]

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

[AinNoGonDoYou]

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

[nehaahmed]

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

[DarkoVlajkovic]

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

[johnylingo]

amazing!! thank you! straightforward, quick explanation!

[abrahamgarcia]

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

[nikolagrkovic]

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

[anthonynorman]

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?

[ahmedJaber]

thank you for this man. wonder if you have built something robust to give rown number for any table; i am facing issues for this

[wonderfulvazquez]

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.

[mrkraymnd]

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

[mardithpascua]

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

[renecernitz]

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

[shreyoshiraychaudhary]

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

[magdalenasokolova]

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