Best Dax teacher in the world 😊

Alberto, you have extended the horizons of 'EXPLAINING' !! ALL THE BEST !!

Very nicely explained RANKX function with examples; explanation was simple to understand and to the point.

Great explanation as always. Certainly made it easier to understand once you visualise that lookup table. Thanks Alberto. 👊👍

I've been using RANKX a lot, but was doing so rather on my gut feeling; thanks to your video, visualing the lookup table makes everything clearer. Thanks for that insight Alberto!

Fantastic as always. Thank you Alberto!

Noone expained ranking tools better. Thank you, Alberto.

Always amazing & descriptive explanation! Thanks SQL BI!

you and your friend understand (I Named you the CIAOS with S) understand very well what you are talking about and know how to teach it to others and that is alone a big skill thank you

Brilliant video. Clearly explains behind the scene for RANKX(), and explains ISINSCOPE()

Thank you! Brilliant explenation, especialy part about how to use Value argument.

Fantastic video, Alberto!

Thank you so much. I enjoy learning from you!

Great explanation. Thank you!

Crystal clear, thank you 👍

Perfect!! I really love how you explained it. Just a question, how can we fix the next situation: We have same summatory values, so, we have in the rating 2 registers with the same ranking. How can we make a difference on those registers? Because I want to use the ranking for to make an accumulative summatory for a pareto chart. Thanks in advance!

Thank you very much for the video. Such a good explanation that I know why we need the 3rd parameter clearly now! In my experience in using RANKX, I am always struggling to find a way to make it work dynamically. What I mean is when we write the DAX to rank, we have to have the target attribute in mind as it will be part of the DAX code, e.g. BRAND. When we can the BRAND to PRODUCT, it doesn't work and we need to modify the DAX code. So I am wondering if there is an effective way to RANK based on the item(s) displayed on the visual? Appreciate your advice.

Muito obrigado por compartilhar conhecimento estou aprendendo muito

Great video man!

Hi! Thanks for the video. Is there any way to ensure that each row in table visual get distinct rank even in case of Ties?

Maravilhosa explicação. Estudantes de DAX do mundo todo se beneficiam de tanta generosidade. Obrigado!!!

Always amazing!

Such a fantastic video! one of the challenges we face in the development sector is to sort people into age groups. these "segments" change from one purpose to another so this is a great way to navigate storage vs. reporting requirements for this information If I may ass a curve ball to this function: Let's say that the sales table holds values in different currencies, and you want to rank based on USD. so, the value we are sending to be ranked has to be converted before you pass it. Oh wait, you just write a measure and pass that! doh! Great content - my previous question is an example of how much I "got it" but please correct me if I totally whiffed

This is a very useful video. I am facing the following situation: - I created a RANKX measure that ranks the Customer by Sales. This works just fine ([Sales] = sum(Sales[Sales amount]) and I am showing it in a table visual - My problem is when I add another measure to the visual. If I add [Order Qty] = sum(Sales[Order Qty], then the RANKX stops working. The Customer[Customer] column is not sorted by other columns. RANKX measure = RANKX( all(Customer[Customer]) ,[Sales] ,,DESC,Dense ) Any help will be greatly appreciated.

THANK YOU VERY MUCTH MrAlberto.This vidio as bonus for me. Reading the book I always thout how looks LOOKUPTABLE it's. and I've some questions. 1.What aboute when selecting Brands in the second exemple. (Statik ranking from 0 to10 000 000 )? Calculatetable(table,Allselected()) dosen't work. 2 What is the diferense between Isinscope() and Hasonevalue()? I allways use Hasonevalue()

Great !!!! Thanks for sharing.... I have one question related to DAX where I can ask that question...

Thank you and see you next week at Servian, Melbourne ;)

Amazing!!

Can you make a video explaining the RANKX to rank users by Category? Like, Ranking on users with level 3. Thank you.

But my doubt here is ALL(product[brand]) should ignore the filter coming from Brand column in visual. But its not doing that. What is the reason?

Sorry, I’m unclear, is there a relationship with the segment table, or does it get the context through data lineage, or…?

Awesome! I now know about ISINSCOPE also! Thank you!

its not working for me: This is my measure: RANKX(ALLSELECTED('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC)) . Ranking size vol is the sum of vol filtered on "Type", The result im getting is not starting with 1 but it starts with 2,2,3,4,5,7 etc when a filter is applied (slicer)??

Good job

Just excellent

Hello SQLBI, Hello Alberto! I had a challenge to rank employees by teams based on their Number of Sales and Sales Amount each month. First I had to rank teams bases on the number of sales and if 2 teams had the same number of sales (let's say both have sold 100 computers) then I had to rank these two by Sales amount (Team X sold 100 computers with sales of 400,000$ and team Y sold 100 computers with sales of 400,500$, team Y is a higher rank). I could not execute this with a single DAX Measure, I had to create a a second Table where I ranked teams... It does work but It takes extra space... I think this should be doable but how...?!

Great

Hi Alberto, Thanks for sharing the video. It is very much useful. Where can I access the data set? If you can guide me.

I'm using RANKX and applying RLS but every end user upon logging always see their rank as 1. How can I make them see just their data but see the overall rank?

I ❤ it

can we rank from based from multiple measures?

I believe the section should be "Dense", not "Dance".... ;)

315 👍

You know DAX better than Microsoft 😮

RANKX is not workinng even after using ALL function. It is still giving 1 for all

Very confusing. Never teach something first and then say it doesn’t work that way. Always show the correct way of doing it first, because we are all keeping our eyes and ears open to learn. When you suddenly say you taught us an incorrect way, it’s frustrating. I stopped watching at 3:30