Excellent! Easy to follow, easy understand, and relatable. I'm amazed at how fast he figured out the Rank+1 miscalculation at 34:00. Great tutorial.

You have just helped me solve a clients requirement I have been trying to fix for over 5 months! WOW thank you!

The value of this video is priceless! Un caloroso GRAZIE dalla Sicilia, Alberto!

I loved seeing how even Alberto spends time looking for a missing parentheses and forgets the return part. I somehow feel less of an idiot now.

Truly masterful. I love peeking into Alberto's brain and see how all the pieces come together in there. A long video, but worth it! Thank you, Alberto!

I really like your way of presenting, slowly but without any gaps in knowledge for the audience. Everything is clear little by little, thank you very much for the useful information

Dear SQLBI team, thank you for your work. Your presentations, like this, are helping me at work.

Another great video from Alberto. Thanks!!! it's pretty awful the lengths we need to go to to work around Power BI's shortcomings. I'm having to use Power BI now because my company has moved away from QlikView. In a QlikView dashboard you can select a Top N as a static or user variable qty and the visuals' properties have a lovely checkbox to "include others" and QlikView just does it - in a split second, no further coding, lots of time saved to do something productive instead.

Alberto once again knocks it out of the park. I was asked by my Exec to do this very thing in December 2020, I wasn't finding very helpful instruction elsewhere, Alberto's step by step instruction were great.

Tension mounts up in a live workshop after a satisfactory search of a good 30 secs for the missing part, experienced the same bermuda spot many times as a trainer. No matter how great you are, it happens for everyone.. I have expected a sophisticated formula for this calculation (coz many new functions were born after 2018 in PBI), but still so many nuts and bolts needed for this Top N products after so many years of product lifespan, I am talking abt Top N. But some DAX patterns were changed i.e budgeting and Basket analysis after the advent of new functions..coz I still remember watching the good old days of Budgeting in Power Pivot and Power BI in the 2015/16, tens of times for good understanding.. Thanks Alberto..meet you one day in India..

Hi Alberto, this was actually very easy to follow up and the fact that you did it in PBI desktop helped a lot. I followed your instructions and got the results I wanted right away. You are so awesome! Thank you so much!

That's truly a masterpiece. It's so complicated, yet you make it so understandable! Thanks very much for the video, sir!

First it seems like "Mission Impossible",but Alberto cracked it. Excellent.

This is better then a Ferrari, it is Sleek and awesome like a Ferrari and yet it is available on you tube for free. Alberto you are GOOOOOOOD!

This is exactly what I did in my previous project, the small change was, instead of making placeholder for others row in the middle, we placed at the end by counting distinct products +1 , then row visible filter logic was to show all products rank

Your videos are the best videos I've ever seen. Many many thanks for all your work.

Thank you so much Alberto, I love how passionate you are about getting to perfection with DAX. Your love for your work is truly inspiring for your students.

Breaking complex requirements into smaller pieces makes it easy to understand. Looking for more videos ..

Thanks Maestro Alberto for the video. This demo shows how important logic and creativity are to good coding. Knowing DAX combined to logic and creativity as you said can solve any scenario you encounter!

I been spending hours to try to solve this problem! Thanks for this video!

Fantastic Video. So helpful. I watched once, then managed to put together what I needed (Pie Chart rather than matrix) using your technique and it worked perfectly. You explained each step so well.

So simple, yet so complex. Excellent Alberto!

Wow.... excellent ! ... solved what i want to do in my management report , step by step on how to do it ... Perfect !

Excellent handwriting, great solution ( thank you for the video ! )

Bravo! This is pure gold. Thank you for sharing, Alberto

Amazing, Alberto. Thanks for sharing your knowledge with us 💕💕🥰🥰. Come to Brazil and bring Marco too. 😁😁.

WoW......I have seen that video thrice to understand the concept.....Thank you so much for sharing your knowledge👍👍👍....

Greeting from Central America, I'm learning a lot with each video. Thank you

This video is so useful. Thank you so much for this. Special Thumbs Up for the way you explained the whole Technique.

Congrats Alberto and team, It is noticeable the production quality.

Cool. I've done my project by your video :D Thanks a lot

As always great stuff, I like the way of providing outlines in the beginning of the video and showing organized breakdown of how you are going to solve the problem. As always great lesson from great teacher. Thank you Alberto Thank you SQLBI team.

Simply Love it sir. Excellent job.

Fantastic Alberto! Thanks a lot for this so useful tutorial. Not only to learn more about DAX, but also for its application to the customers requirements.

Brill! Thanks for giving that fantastic solution. Not that easy, but I was able to recreate everything and I will present it to my fellow colleagues soon. It is always a pleasure watching your informative and useful vids. Cheers, Vin aka Pia

OOOhhh ... a heavy dose of DAX! Thank you Alberto, cool report.

Thank you very much, good, good, ideas and resolution is perfect.

Just practiced it with my dataset. it works like a charm. love the contents and i am reading thru your book as well. thanks.

A very very good video, thanks for sharing your insights and methods on making this customization.

this is amazing. I thought you were writing it on the spot. regardless, genius

Thank you so much Alberto. be blessed

Thank you so much for the excellent video, very well organized and presented. One suggest, if I may make, please please make the size of your curser larger or make it transparent, I had difficulty following where you were clicking.

Great, Alberto! I would add a little change: 1. If there are less products that TopN, then no need for Other, so it should return BLANK() and not zero (at least in my scenario). Thanks!

A very useful and understandable topic! Thank you! Time to start the book!! :)

Great video. Very educational. I think the Top3Prods at 27:00 is unnecessary, it is already down to these top product (and others but the value is zero in this stage).

Thank you so much... you are a truly teacher

Thank you for another excellent and educational video! These are really appreciated! After watching the first video on the TopN function in DAX Studio, I had the same thought as the other viewers like you mention in the start of the video 0:49.. Though this video was excellent, what I am "missing" is link between the complex query in DAX Studio and Power BI. How do I, step by step, code piece by code piece, move my query from DAX Studio to a useful measure in Power BI? If you could make a video on this it would take the understanding of DAX for a lot of us DAX developers to a whole new level.

Thank you very much for this great tutorial!

as always, I have to watch 2 times. Love u, Alberto :)

Thank you, it works perfectly! I had to twek the formulas a little because my project works with YTD :)

Alberto you are a master!!! great video, I spent a lot of time thinking about the logic used to solved the problem and this is just excellent, easy to understand once you follow your recommendations. Thank a lot please to continue creating sensational videos as this one

Amazing video, thanks a lot. I am learning so much in your channel.

Awesome video Alberto! You've done my life much easier. Cheers!

Thank you for this video. It has been very helpful!

Thank you very much Alberto. Very good as always

Thank you for the detailed explanation. This helped a lot!

Thanks Alberto, as always very well explained Ideally would have the year as a column in the matrix, so one could compare the rankings over the years 🤔🤔

Excelente video, genial la utilización de los parámetros para volver el TOP dinámico y genial la manera como se resuelve por medio del condicional del rankin la fila "otros" para las visuales. Muchas gracias.

Alberto, instead of assigning a dynamic rank to the "Others" item, you could take the absolute max from the TOPN table, add 1 to it, and assign this to the "Others" item as the rank. This way you don't have to think too much about the arithmetic and it'll work just as fine. Of course, in the measure that governs the display of the rows you'd need to just add an OR condition to account for the "Others" row. And the ranking could still be used for sorting. The basic idea here is to assign the (max of the TOPN table + 1) to the "Others" item. If you still don't want to think too much, just assign plain 10000 to "Others" as its rank and account for this in the row-filtering measure as before using OR. Sorting will work fine again.

Thanks Alberto. I know what my team is going to work on today :-)

I did NOT watch the whole video because , i want to try to solve this problem myself 😀 . Time to get started 😅

VERY USEFUL!!! Thanks Alberto!!

Great video! I created a bar chart using the logic. Is there anyway we can drill down on "Others" too see the details?

Truly Genius, Alberto! Thank you very much and Marco for all your work. I started studying DAX two years ago with SQLBI and your patterns. I wanted to ask if it is possible to use MDX inside PowerBI, I sometimes use it creating named sets in Excel and was wondering if you know any features or secrets about it. 🙂

very useful vid! I would like to group up the blank values with the 'Others'. How would I achieve this?

Great tutorial

Awesome, it definite takes reports to the next level. It´s difficult but it worths.

Excellent tutorial. Really helped me a lot

Great video thanks!

Numero uno, grazie mile

Thanks a lot Sir for the detailed explanation

that was amazing and inspiring! I'll be watching again and practicing

Hi Alberto, Till the video timeline 20:56, was awesome and I was about to become your fan. But after that, you messed up the whole. Sorry to say here, Gap No.1: you could have made the Ranking of "Others" = Rank + 1 dynamically. Gap No.2: Easily you could have calculated Others Value = Group Total - (Sum of Ranked Product's Value) Anyway, Good initiative, and I must appreciate your communication and teaching skills.

godfather of dax

Great Video Alberto. I have a question. I add the customer name to the rows. I can't understand why i am getting rows with no sales. What should be changed to not show those rows?

If so common, why isn't this an automatic feature in PBI? Another great video - thanks!

Great video thanks

Eu sempre fico maravilhado com podemos voar apenas com alguns minutos de conhecimento de qualidade! Como sempre digo: "Aprenda algo novo todo dia". Esse foi meu novo de hoje. VAleu!!!! #powerbinareal

Your videos are top notch! Its not just the knowledge but your presentation of it is essentially flawless. Great content, great audio, great video (using the stream deck :thumbsup:) and doing the on-screen inking is the cherry on top! I have to ask, since I'm currently in the market, what's the tablet you are using for that (and app if you needed one)?

tnx very much! awesome!

Fantastic!

He is a master, but this difficulty level for creating just Others shows how MS Power BI has a profound problem. Tableau solves this dynamic issue with a click!

thank you very much

You are amazing 🎉

Thank you Master, very didactic class!!

Thanks Alberto for very helpful tips. One question about Ranking measure - why you didn't use [TopN Value]+1 instead of 4 in IF( IsOtherSelected, [TopN Value]+1... This way you can filter not only TOP 3 but TOP N products.

Thanks for the video. I have created the table consisting of top 3 product in order of sales but in row total i want to get total sales and not sales of top 3 products. Can you please help regarding this

I followed this video perfectly and was thrilled till I realized I need to have a matrix with columns being the last 18 months. When adding the date field and making it a matrix it doesn't seems to work. Is there a way to do Top N and Other with a matrix? And the Top N based on the total of the year, not each month?

Great and very clear ! Thank you.

Sempre TOP!

I have a survey where we asked in the rank of same products as 5 questions - Rank 1 - A/B/C/D Rank 2 - A/B/C/D Rank 3 - A/B/C/D Rank 4 - A/B/C/D Any easy way to calculate these options A,B,C,D on the basis of rank weight?

Hello Alberto, this was awesome and thanks, I have one last question, If I want to display the information in a chart instead of a table, how do I sort the data in a graph similar to the table view. ? please do help me with an answer.

Thank you for the insightful video; it was truly valuable. However, I encounter another challenge. I'm working with around 20 categories within my dataset. The complexity arises from the need to dynamically filter the data, with the number of categories being filtered varying each time. Sometimes, I might filter by 3 categories, while at other times, I could require filtering by 5 categories. Is there a way to automatically aggregate the remaining categories as "Others" based on the selected filters, and subsequently visualize this as a pie chart? Your assistance is greatly appreciated. Have a wonderful day ahead!

Great thank you for all videos

Top notch video! Thanks a lot for this. I have a question tho. Instead of a Whatif table to generate N values, I limited the slicer to show top 5,10,20 and 30, and all worked well. However, I also want to add an “All” option to the slicer, when I choose which all the data will be displayed in the matrix, sorted descendingly. I’ve been trying to solve this for a while but couldn’t. Do you have any suggestion? I’m very grateful for any help.

Amazing!

Thank you

Brilliant!

Wow. Incredibly useful. I have a composite model and joining to the large product table is very expensive. I'm wondering if something similar could be accomplished with a simple rank table containing only the rank numbers. Could this then "lookup" the products at that rank position? Now, might that work with fuled parameters for the dimension you want to rank/display?

Muy inteligente profe. Gracias!