Intermediate Power BI - How to rank using RankX
Vložit
- čas přidán 7. 09. 2024
- 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...
Great job of explaining how RANKX works. Thank you!!!🔥🔥🔥
Seen many videos but thanks to you that my rankx works. :)
Awesome!
straight to the point thank you! I finally got my rankx working
amazing!! thank you! straightforward, quick explanation!
perfectly explained with errors that could come up, thank you so much :)
you REALLY HELPED ME, a Lot of Peopple didn't explain about doing a duplicate by callyng Totals; THANK YOU
THANK YOU THANK YOU THANK YOU, AFTER 2 MONTHS, FINALLY
You made my day.....saved a lot of time....
Great explanation 👏🏻
Thank you so much❤
Thanks man
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?
Excellent!
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
Thanks a lot! Was really helpful
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.
What’s the benefit of rank in this case rather than just sorting the value largest>smallest
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.
God Bless you
Best resolution found
Hi, why is the ranking not proper when using All('Table')?
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
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
can you please make it work with all selected but with the 2 columns of string values not just one?