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!
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.
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
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.
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)??
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.
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...?!
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
