Тёмный

Intermediate Power BI - How to rank using RankX 

Willy1987
Подписаться 1,3 тыс.
Просмотров 28 тыс.
50% 1

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...

Опубликовано:

 

19 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@MrVargs120
@MrVargs120 Год назад
Great job of explaining how RANKX works. Thank you!!!🔥🔥🔥
@AinNo1GonDoYou
@AinNo1GonDoYou 3 года назад
straight to the point thank you! I finally got my rankx working
@nehaahmed46
@nehaahmed46 Год назад
Seen many videos but thanks to you that my rankx works. :)
@wllymchng
@wllymchng 10 месяцев назад
Awesome!
@johnylingo4673
@johnylingo4673 Год назад
amazing!! thank you! straightforward, quick explanation!
@nikolagrkovic8769
@nikolagrkovic8769 2 года назад
THANK YOU THANK YOU THANK YOU, AFTER 2 MONTHS, FINALLY
@DarkoVlajkovic
@DarkoVlajkovic 5 месяцев назад
perfectly explained with errors that could come up, thank you so much :)
@abrahamgarcia6818
@abrahamgarcia6818 2 года назад
you REALLY HELPED ME, a Lot of Peopple didn't explain about doing a duplicate by callyng Totals; THANK YOU
@VarunKumar-xt4jq
@VarunKumar-xt4jq 7 месяцев назад
You made my day.....saved a lot of time....
@608er
@608er Год назад
Great explanation 👏🏻
@praveen26699
@praveen26699 9 месяцев назад
Thank you so much❤
@wllymchng
@wllymchng 8 месяцев назад
Thanks man
@bhakthasingh8198
@bhakthasingh8198 2 года назад
Excellent!
@anthonynorman1212
@anthonynorman1212 2 года назад
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?
@ahmed007Jaber
@ahmed007Jaber 24 дня назад
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
@sum1257
@sum1257 2 года назад
Thanks a lot! Was really helpful
@echezonaazubike8054
@echezonaazubike8054 2 года назад
God Bless you
@mrkraymnd
@mrkraymnd 2 года назад
What’s the benefit of rank in this case rather than just sorting the value largest>smallest
@wllymchng
@wllymchng 2 года назад
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.
@shreyoshiraychaudhary8808
@shreyoshiraychaudhary8808 8 месяцев назад
Hi, why is the ranking not proper when using All('Table')?
@sahilmittal1382
@sahilmittal1382 2 года назад
Best resolution found
@mardithpascua8112
@mardithpascua8112 2 года назад
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
@wonderfulvazquez7957
@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.
@magdalenasokolova9073
@magdalenasokolova9073 2 года назад
can you please make it work with all selected but with the 2 columns of string values not just one?
@renecernitz4786
@renecernitz4786 3 года назад
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
Далее
Introducing RANKX in DAX
19:42
Просмотров 32 тыс.
Introducing RANK window function in DAX
15:24
Просмотров 27 тыс.
Using ALLEXCEPT vs ALL VALUES
13:35
Просмотров 55 тыс.
📊 How to use Power BI DAX - Tutorial
37:28
Просмотров 1,1 млн