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
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!
But problem is if you add two categories in table, you need to mention both headers under ALL dax so to avoid Filter context. Can we do anything here which doesn't need column names wrapped under ALL because I may change fields in table. Then I have to change column names accordingly. Pls reply.
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.
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
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()
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.
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?
If you are using import mode, is there any possibility to calculate rank in calculated column instead of a measure. So that values are stored in table rather than always getting calculated on the fly in measure. Not sure if it will work But just a thought.
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)??
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
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...?!
Best Dax teacher in the world 😊
HIS is a magician of DAX
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
Very nicely explained RANKX function with examples; explanation was simple to understand and to the point.
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!
Always amazing & descriptive explanation!
Thanks SQL BI!
Thank you!
Brilliant explenation, especialy part about how to use Value argument.
Noone expained ranking tools better. Thank you, Alberto.
Great explanation as always. Certainly made it easier to understand once you visualise that lookup table. Thanks Alberto. 👊👍
Fantastic as always. Thank you Alberto!
Brilliant video. Clearly explains behind the scene for RANKX(), and explains ISINSCOPE()
But problem is if you add two categories in table, you need to mention both headers under ALL dax so to avoid Filter context. Can we do anything here which doesn't need column names wrapped under ALL because I may change fields in table. Then I have to change column names accordingly. Pls reply.
Fantastic video, Alberto!
Thank you so much.
I enjoy learning from you!
Great !!!! Thanks for sharing....
I have one question related to DAX where I can ask that question...
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!
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?
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.
Crystal clear, thank you 👍
Great explanation. Thank you!
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?
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
Hi Alberto,
Thanks for sharing the video. It is very much useful. Where can I access the data set? If you can guide me.
In the description you can find the link.
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()
Maravilhosa explicação. Estudantes de DAX do mundo todo se beneficiam de tanta generosidade. Obrigado!!!
Always amazing!
Muito obrigado por compartilhar conhecimento estou aprendendo muito
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.
Great video man!
Thank you and see you next week at Servian, Melbourne ;)
Marco is in Australia, not Alberto!
Can you make a video explaining the RANKX to rank users by Category?
Like, Ranking on users with level 3.
Thank you.
Sorry, I’m unclear, is there a relationship with the segment table, or does it get the context through data lineage, or…?
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?
If you are using import mode, is there any possibility to calculate rank in calculated column instead of a measure. So that values are stored in table rather than always getting calculated on the fly in measure. Not sure if it will work
But just a thought.
Just excellent
Good job
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)??
Awesome! I now know about ISINSCOPE also! Thank you!
Amazing!!
can we rank from based from multiple measures?
You can with the new RANK version: dax.guide/rank/
@@SQLBI how about dax in excel?
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
Great
I ❤ it
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...?!
I believe the section should be "Dense", not "Dance".... ;)
315 👍
RANKX is not workinng even after using ALL function. It is still giving 1 for all
Check the sample file you can download from the article and compare it with your model.
You know DAX better than Microsoft 😮