TopN CONFUSION in Power BI | When the Top3 DOESN'T return 3 items

TOPN can be very confusing as it can be interpreted in many different ways. In this video I walk you through some practical TOPN scenarios. Enjoy the video and subscribe for more Power BI hacks!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:40 When a top 3 filter returns more than 3 items
1:26 Rank all items with the TOPN values
05:21 Filter all items with the TOPN values
06:19 Setting the TOPN value using what if parameters and slicers
08:11 TOPN by category or overall?
11:41 TOPN %
16:39 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[rantaleksi]

You are by far the best Power BI teacher I've found on Youtube. Your examples are well thought, and I like it that you walk through the mistakes that anyone would likely face when building measures or visuals. Keep it up :)

[williamarthur]

Great video on my bugbear function, also thanks for reminding us all about wrapping the Sum in calculate if not using a measure, it's one of those really important things and could have a video in it's own right as to when and when not necessary.

[uberleetmike]

I am subscribing to your page after this example. Exactly what I was looking for including the "ALLSELECTED" based on multiple key fields. Thank you!

[madiakns]

TopN confusion is "Ranked" high in my all dax confusions. 😊

[Luc-tkoy]

Out of all Youtubers on PowerBI, I love your explanations most! Question, if you wanted to select the top 2, but exclude 1 specific employee (for example, exclude Sally Grant; 12k), how would that be done? In my case, I have a 'other' category, which I never want to have shown.

[adityaagrawal]

You are always my savior. I always find solution for my PowerBi problems.

[joaquimcosta]

I discovered this channel only now. Very useful. Thanks for your work.

[sanksu]

Nicely explained, now no confusion. I like all your videos. Those are very helpful!!! Thanks!!!

[YourFavoriteYoutuberVivaan]

Your ideas and way of explaining are awesome! Instead of using parameter for top 10 filtering, whether adding slicer with column ( employee ranked based on salary) would also work? The slicer can filtered for 10 values.

[DilbagSingh-vfgv]

hey, in explained scenario in the video, isn't 'IF' function working in reverse, as 'IF' condition is if employee rank is >= 20 then return 1 and in filter we add "is =1" which then filters ranking >= 20 and return all the values.

[virajphadnis]

One more clear and useful video, I make it a point to use most of these whenever required, really helpful for many of us. Thanks

[boozern]

good video but unless im missing something there was nothing to limit the TopN to the NUMBER of records I wasn't to display which was the primary reason for coming here as the title suggests...

[danielsiffredi]

That was art! this open my mind to do some very cool things on my reports. thanks!

[vini_sepol]

You helped me a lot! Thank you so much for this amazing content!

[enricomeggio]

Can anyone explain me how to obtain the right total of the topn rows?

[joserobertodantas]

Nice video... Btw, I was expecting a solution so the Top3 would return 3 items =/

[DilbagSingh-vfgv]

In my case, i need Top 20 and Bottom 20 customers based on their NetSales when i select slicer "Top 20 Customers" and Bottom 20 Customers" respectively. can this be achived with explained approach in the video?

please share your insight why Below measure is not working
CustomerTopNfilter =
VAR x = IF
( [CustomerRanking]<= [Measure which returns value 20 when Top 20 Customer slicer is seleceted], 1,
IF ( [CustomerRanking]> [Measure which returns x value when Bottom 20 Customer slicer is seleceted], 0
)
)
return
x

[gulmohar]

Thank you for the video, great content. Could you also please do a video on showing a random set of rows from a table?
Like if I have 1000 records for the given context and I need to see 10 random rows, not based on any ranking, so that the next time I need to see 10 rows, they'll be different from the ones I saw earlier.

[anoopdube]

RANKX function is not throwing expected outcome. Happy to share my code if you like. Any help will be highly appreciable.

[TechTeacherTT]

This is very useful for me and lots of other people!!