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

[@rantaleksi7086]

You are by far the best Power BI teacher I've found on KZbin. 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 :)

[@bimalpatel7758]

Then you not seen video of excelisfun guys

[@1thiagocruz]

Totaly agree.

[@Luc-tk5oy]

Out of all KZbinrs 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.

[@williamarthur4801]

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.

[@adityaagrawal9736]

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

[@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. 😊

[@HowtoPowerBI]

Haha 😄 i guess you are not the only one 😉

[@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.

[@joaquimcosta952]

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

[@DilbagSingh-vf6gv]

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.

[@sanks4u]

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

[@HowtoPowerBI]

thank you for watching Sanket!!! 🙂

[@DilbagSingh-vf6gv]

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 x value when Bottom 20 Customer slicer is seleceted],0 ) ) return x

[@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

[@HowtoPowerBI]

Great to hear! thx Viraj!!! 😀

[@pankajpatle5970]

Hey Bas, Your videos are really helping me in my work. I have to project Bottom 10 or 20 in my project but it should exclude zero values. How can it be done? Your help would be really appreciated.

[@syedmaazsaif]

Is there a way to have top n filter to ingore a product and move to next one. Like if i want to not include product 3 but instead want 4 then 5 etc . Is this possible

[@shanzeafreen8335]

Will this approach work if my measure (total salary in your example) is a product function of two column from different tables. Confused what table should I refer while writing rankx. #howtopowerbi

[@529deepaks]

Hi Bas, Thank you for amazing videos. I need one urgent help. I want 3 card visuals in my report. First will show highest selling brand along with sales amount, second will give second highest selling Brand along with sales amount and similarly for third. I tried a lot but no luck. Can you pls guide me here with measure or anything. Thank you!

[@VinyuS]

I have a similar issue but in my case i really have to calculate with only 10 in case of TOP10, if i take your example how could you calculate the average salary of the 10 best payed employee?

[@rvheadhunter]

Bas, how to count RT % of sales - total qty

[@enricomeggio84]

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

[@vini_sepol]

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

[@ccm284]

you solved my problem in 9 seconds.

[@arinbose5778]

Sir i cant find the filter type option in my sliced chart or other visual reports. Please help

[@Crysteps]

Hey Bas, Thank You for your videos. I'm a new subscriber and am really enjoying the way you teach DAX. Any thoughts on the New "Upgraded" DAX Intellisense that came out with the latest PBI Update ? ;)

[@anoopdube9581]

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

[@DilbagSingh-vf6gv]

hello

[@hainsay]

In the same vein of difficulty selecting things, if I have a measure that is limited by a date range, and I want to show all the dates in the range even if the measure has a value of zero, how do I go about that? All my attempts end up with "all dates" in my date table

[@hainsay]

Found a solution but I don't like it too much measurename = vars and stuff var firstdate = var lastdate = return measure calculation + if (min(calendar date) = firstdate, 0, BLANK() )

[@danielsiffredi8403]

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

[@HowtoPowerBI]

Awesome 👊 ! Haha art 🎨 , too much credit 🤣 .. thx Daniel!!!

[@RakeshKumar-gr1yg]

Awesome videos, great content everytime, kudos to that!!!! Although I have a question, what if we want to see the rank of a department also in the same visual? could you please throw some light on that.

[@HowtoPowerBI]

will do, that topic deserves a video on its own

[@navneettaneja3198]

on distinct value can we use

[@500iq6foot8]

Anyway to get a chart to auto drill down when only one item is left in the filter?

[@HowtoPowerBI]

I don't think that's possible 🙄

[@rvheadhunter]

@@HowtoPowerBI please help, how to count % of running total - total qty

[@RobertoStaltari]

You've used both ALLSELECTED and REMOVEFILTERS. Are they interchangeable?

[@HowtoPowerBI]

Hi Roberto, thx for watching! They are not the same -> When used inside of the calculate function both ALL and REMOVEFILTERS are the same. ALLSELECTED would remove the filters from the visual, but not outside filters (from a slicer, filter panel or other visual). In the rankx function I use the all function to return all the rows in a table, or all the values in a column, ignoring filters, and allselected if you want to keep filters from outside the visual. The rankx function then iterates over that table. REMOVEFILTERS can only be used to clear filters but not to return a table like all and allselected, so therefore wouldnt be an option here.

[@rvheadhunter]

@@HowtoPowerBI please help, how to count % of Running total of sales - total qty ??

[@gulmohar5441]

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.

[@HowtoPowerBI]

thanks for the Idea Gulmohar! sounds interesting, what is the practical application you need it for?

[@TechTeacherTT]

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

[@HowtoPowerBI]

So nice to hear, thx for watching 😊

[@TechTeacherTT]

@@HowtoPowerBI no worries. I think the topN funcfion can indeed be very confusing especially when thinking about rank . That's why I wanted to dedicate a video to it as well. In th

[@rvheadhunter]

@@HowtoPowerBI please help, how to count % of running total - total qty..

[@ashishmohan4707]

Wow again with new amazing video bas

[@HowtoPowerBI]

Thx so much Ashish 😀

[@trinhtruong4392]

so touching for an excellent video

[@harishstark]

Scheduled refresh is slow when compare to manual refresh You guys know anyother way to do automatically using other apps Like power shell or python

[@joserobertodantas1516]

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

[@mehdihammadi6145]

Thanks for sharing

[@HowtoPowerBI]

thx for watching Mehdi 😀

[@matthiask4602]

very helpful, thx!

[@HowtoPowerBI]

Glad to hear that! thx Matthias! 😀

[@isjajo]

This was very helpful, thx

[@HowtoPowerBI]

😀 thanks for watching Jacob

[@rajm5349]

useful video thnks fr that, bt i did not understand % concept

[@HowtoPowerBI]

thx Raj! Let me clarify TopN% -> If you want to return those employees that earn more than the median salary - that would be top 50% .. in the video I make that a bit more flexible and you could also choose any % , for example top10% employees based on salary

[@oleg.ostrokomorets]

Это прекрасно!

[@HowtoPowerBI]

Спасибо :)

[@sands7779]

so clear

[@stephanemesnildrey105]

Hello Top👍 de "France"

[@frankgovers8420]

Bas, great!! Cudo's

[@HowtoPowerBI]

thank you Frank 😊

[@sonalisahu806]

First like 👍

[@HowtoPowerBI]

Yey 😁🥳

[@sonalisahu806]

@@HowtoPowerBI Thanks for sharing this video 👌 It will resolve all the issues faced in TOPN 🙂

[@emilyamalkin4367]

You are an amazing teacher!

[@schajuli1991]

RankByAmountFails = RANKX(ALLSELECTED(DimCustomer),SUM(DimCustomer[Amount])) What is wrong with this one? It is still giving me always 1 for ranking although the amounts are different. E.g. the following is working as supposed ... RankyByBirthdayWorking = RANKX(ALLSELECTED(DimCustomer),FIRSTDATE(DimCustomer[BirthDate])) Edit: Ok, I see using Calculate or using a Mesure for Sum is the way to go again here .... Edit2: Ok, I should first watch videos till the end :D