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!
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()
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!
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 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.
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.
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)??
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...?!
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
![“อ.เบียร์ คนตื่นธรรม” มาตามคำเรียกร้อง แหกศาสตร์ฮวงจุ้ย เตือนสติอย่างมงาย | แฉ 7 พ.ย. 67 [1/3]](http://i.ytimg.com/vi/5fc4S3xBNfc/mqdefault.jpg)
Best Dax teacher in the world 😊
HIS is a magician of DAX
Very nicely explained RANKX function with examples; explanation was simple to understand and to the point.
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!
Noone expained ranking tools better. Thank you, Alberto.
Always amazing & descriptive explanation!
Thanks SQL BI!
Thank you!
Brilliant explenation, especialy part about how to use Value argument.
Great explanation as always. Certainly made it easier to understand once you visualise that lookup table. Thanks Alberto. 👊👍
Brilliant video. Clearly explains behind the scene for RANKX(), and explains ISINSCOPE()
Fantastic as always. Thank you Alberto!
Fantastic video, Alberto!
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 so much.
I enjoy learning from 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?
Maravilhosa explicação. Estudantes de DAX do mundo todo se beneficiam de tanta generosidade. Obrigado!!!
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 explanation. 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!
Great !!!! Thanks for sharing....
I have one question related to DAX where I can ask that question...
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.
Crystal clear, thank you 👍
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.
Thank you and see you next week at Servian, Melbourne ;)
Marco is in Australia, not 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.
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?
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.
Great video man!
Awesome! I now know about ISINSCOPE also! Thank you!
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.
Always amazing!
Muito obrigado por compartilhar conhecimento estou aprendendo muito
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)??
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…?
Just excellent
Good job
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?
Great
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 ❤ it
I believe the section should be "Dense", not "Dance".... ;)
You know DAX better than Microsoft 😮
315 👍
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
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.