You cant imagine how your videos have helped me in my current job, you are a lifesaver! Thank you, keep up with the good content!🎉

Thank you so much!

One can find so many videos related to dynamic top n, but this one is the best till date on the internet

This was amazing. Thank you very much for making this tutorial.

Very good work but when you change the parameter, the total does not change, how to fix it?

I was looking for that content for a long time! Thank you!

Fernan, Great video as always, In this video, I noticed that the Total for the top N is the same as the total for the entire table

the total is not dynamic

Right on the spot what i was looking for.

This tutorial helped me a lot.

Thanks for making this. Good Explanation

top N and by different categories. can we do that as well? say two parameters, one is top N , another one is by country, by product, by entity etc.

Solved alot Questions. Great to learn from you.

Very Interesting Demo !!!

The total doesn't change with the parameter value. How can I change that?

Hi..The total amt in the table is not reflecting correctly. Eg. For Top 5 countries, the total Sales should be 848,171.48. However, as per the table, it shows 13,54458.59. How to correct this? ,

there is issue here that the total of table is not changed

Thank you so much for helping me understand this procedure ^^...

Thanks❤

Fantastic! 🎉🎆 Always love your videos! Always to the point, useful ones and very informative!

Perfect! however I tried to add another column in legend and it didn't work, so to use your example I wanted to show Countries, categories and use the rankx over that

After applying If conations the rows are not being filtered. i am able to see all the countries with the blank values & the TOP N values with the sales values

Thanks!

Very good stuff mate

Awesome content.

Hi @Solutions Abroad, I like this tutorial. But, If you absorb Total of Top 5 and total of Top 10 are same, they're not changing. How to get the total as well, as per for TopN?

Awesome!!

amazinng explanation!

great work

The sum of Total values of topn are wrong, how can I fix?

Thank your video's. Always very clear when explaining. I have one question. I tried using the parameter for the ranking in my dashboard. When I place the rank on 5 for example, I only get 4 results in my table. What can I do to fix this? Or what am I doing wrong.

Hi thanks! What if a want to see the top 10 Products but also have a column named region to see from which region they are, but not giving me top 10 for each one?

Great video but doesn’t work in my case 😢. Rank does not rank my values.

that's great! thanks for the videos. Please i have a question: when i do that for top and bottom, it seems to rank well, I actually set so that it will just rank those category with have a value , however there are some that are empty, and so the ranking works fine for top but then bottom will only display the range i selected minus 1, meaning that i select Bottom with a range of 3, so Bottom 3 categories, it shows me all categories that rank 1 and 2 but not 3 even is correctly ranked, and is not ranking the categories that have no values. Any suggestions? the top 3 categories display fine but not when i select bottom. the formula is the same except for the ASC and DESC part

That was great mate. I do have a question. How can I change the labels and color of a graph 📊 as I drill down into it?

Hi, Bought silver membership, still not able to download demo files of this video. Please fix it soon

Very insightful How can you make this work with a Card visualization? Tried, and the Card always provides the total regardless of N selected

Does this Parameter changes value in other visualizations too?

Hi, I tried the same dax formula but not working, every row shows rank 1.

What to do to have correct sum of top selected in the table?

Hi is there someone who can help with ranking sales by month?