When & How to Use TOPN in Power BI - DAX Function Tutorial

No video

When & How to Use TOPN in Power BI - DAX Function Tutorial

Рет қаралды 94,059

Күн бұрын

Here I detail how to use the TOPN function in DAX. This is a really versatile function to be used in Power BI and it can be used in many different ways to extract great insights into your data.
****Video Details****
0:44 - Introduction
2:02 Using CALCULATE and SUMX With TOPN Function
5:26 Other Ways You Could Utilise The Formula
6:51 Conclusion
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
FREE - Power BI Resources - enterprisedna.c...
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Ranking Insights Using TOPN In Power BI
blog.enterpris...
Discover Unique Insights Using Power BI TOPN Function
blog.enterpris...
Different Ways You Can Use The TOPN Function - DAX In Power BI
• Different Ways You Can...
**** Related Course Modules ****
DAX Formula Deep Dives
portal.enterpri...
Advanced DAX Combinations
portal.enterpri...
Mastering DAX Calculations
portal.enterpri...
**** Related Support Forums ****
Filtered top N Table
forum.enterpri...
Part 2: Combining Dynamic Attribute Slicer, Dynamic Measure Slicer, and Dynamic TopN /RANKX Slicer
forum.enterpri...
Top N and an Others Bucket
forum.enterpri...
For more TOPN queries to review see here…..
forum.enterpri...

Пікірлер: 27

@EnterpriseDNA 7 жыл бұрын

Hi all, please forgive me, but there is a significant error in the formulas in this video which Leonardo has pointed out below in a comment. (possibly could be to do with the late night recordings! who knows) Anyways....If you are looking to rank by say 'Total Sales' then the third parameter needs to be 'Total Sales' not the column name. TOPN will rank based on the 'order by expression' you give it. So you could order by anything. Through the error in this video I have ultimately rank by alphabetical order which obviously is a pretty useless insight if you think about it. This is a perfect example where you can get results and then think, ok I must have it correct when actually it is totally wrong and calculating something that to very different from what you were looking to achieve. Anyway please note this. I will use this technique a lot in the future as it's a great way to discover insights fast. Until next time. Chrs, Sam

@andreameade92 3 жыл бұрын

The error has confused me and I believe it should be DESC not ASC. Is there an updated video on this topic?

@ramvikram122 4 жыл бұрын

You are seriously the best instructor I have come across in KZfaq. Thanks for all these great videos.

@ahmed007Jaber 17 күн бұрын

Thank you for this mate. what I was thinking of is flagging out the actual top products. what would the calculate function look like? calculate(customers, topn(.............ect?

@Mikkeldamsam 7 жыл бұрын

Keep up the good work, videos are super easy to understand - getting a lot out of following this channel - simply one of the best channels if you want to get better with power bi. Thank you Sam.

@EnterpriseDNA 7 жыл бұрын

No problem. Chrs

@badmephisto2 Ай бұрын

Hello, Topn is useful when it shows only the top 2 products or top 10 customers from the whole list, but in your formula all the products are highlighted in the table without any segregation. So, what's the benefit? If i am doing some mistake in understanding your working, please clarify. Thanks

@OmarAlvarezGarcia 5 жыл бұрын

Hello Sam, Is it possible to add another row with the total sales for the rest of the customer? In your case, right after Virginia called "sales other customers"

@RahulDas-os3rg 4 жыл бұрын

Hi there, In the top customers through time video you have used DESC to get the top 10 customers but here you are using ASC. I am bit confused can you suggest which is correct , what exactly I need to use while calculating the TOP N values. Whether it should be ASC or DESC kindly clarify my doubt.

@negisaab74347 2 жыл бұрын

For top N it should be desc

@DIGITAL_COOKING 4 жыл бұрын

claire explanation ! 👍

@3danim8r1 4 жыл бұрын

Nice

@lauricevillarino8713 3 жыл бұрын

Thank you for this!! Is there a way I can export my topN table with slicer? Whenever I export to excel, it exports the whole rows (sample: 50 rows instead of the top 10) Thank you so much!!

@EnterpriseDNA 3 жыл бұрын

Hello Laurice Villarino, thank you for posting your query onto our channel. Once you select the slicer and have the results for the "TOP 10" then select the table visual that you want to export and on the top-right side of the visual click onto the 3 dots (...) and select the option of export data. And now, you'll have the filtered data in the Excel file. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/

@BIMoji1 6 жыл бұрын

Thanks for the Video. Is there a way to update the TOP N numbers dynamically from the report? Like TOPN(Variable) and This Variable should change based upon the Slicer drop down values.

@EnterpriseDNA 6 жыл бұрын

Here's how you can do this - kzfaq.info/get/bejne/iZ2VgMaUtJfDknk.html

@thomaslyons3700 6 жыл бұрын

As written, is the ranking the top two products taken over all states, or the unique top 2 products within each state? And how would one do the way that this isn't (i.e. contrast)? :) Thanks, very informative video.

@EnterpriseDNA 6 жыл бұрын

There is a small issue with the formula, as mentioned in the other comment (I'll be updating soon), but regarding your question, it depends in which context the calc. is in. Because it's being filtered by each state at each row in the table it is by state, but if it wasn't then it would be across all states.

@oscarkatsinis6817 7 жыл бұрын

Excuseme, to download the KZfaq models, I pay $47 for downloading all the models that are shown on KZfaq? Or it's just the one you're seeing. Regards

@EnterpriseDNA 7 жыл бұрын

All the training resources on KZfaq (currently there is about 50). At portal.enterprisedna.co. You can see every resource which is included. Chrs

@macemalakai 2 жыл бұрын

Newer to Power BI, but why did the TopN function designating a "10" result in 10 rows being returned?

@EnterpriseDNA 2 жыл бұрын

Hello Troy, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, actually we're not able to understand your query here i.e. the context that you're trying to highlight and the explanation of the concept that you want from us. We sincerely request you to please write back to in an elaborate manner by highlighting the query that you've and the explanation that you would like from us so that we can explain you in a better and efficient manner and it'll help you to strengthen your understanding of the fundamentals or concepts. Hoping you find this useful. Also, make sure that you're subscribed to our KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

@shyamthakur1393 5 жыл бұрын

hi...suppose i have 50 rows and i have used Rank for top 20 record and rest i want as " all others" how to achieve that ???

@EnterpriseDNA 5 жыл бұрын

For help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/

@mohdmuzammil3059 3 жыл бұрын

When to use Rankx & Topn

@EnterpriseDNA 3 жыл бұрын

Hi mohd muzammil, thanks for posting your comment here in the video. This topic has been discussed several times in Enterprise DNA Forum. You might get the answers you are looking for. If you want to check it out here is the link: forum.enterprisedna.co/search?q=Rankx%20%26%20Topn