When To Use TOPN In Power BI - DAX Formula Review

TOPN is a great DAX function to use in Power BI when you have some internal ranking logic that you want apply to your calculation.
There are many occasions where there is a better formula combination to use than the alternative of RANKX.
There is a lot reviewed around this topic in the tutorial so, enjoy!
Sam
**** Video Details ****
1:17 - total number of cities with purchases
3:08 - calculating the top two cities
5:50 - calculating the bottom two cities
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - Power BI Resources - enterprisedna.c...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Discover Unique Insights Using Power BI TOPN Function - blog.enterpris...
Ranking Insights Using TOPN In Power BI - blog.enterpris...
First Purchase Of Customer Insight Using DAX - blog.enterpris...
**** Related Course Modules ****
DAX Formula Deep Dives - portal.enterpr...
Mastering DAX Calculations - portal.enterpr...
Business Analytics Series - portal.enterpr...
**** Related Support Forum Posts ****
TOPN Bottom Is Blank - forum.enterpri...
RANKX Vs TOPN What Is The Difference? - forum.enterpri...
TOPN With Multiple Dimensions - forum.enterpri...
For more TOPN support queries to review see here…. - forum.enterpri...

[@EnterpriseDNA]

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Discover Unique Insights Using Power BI TOPN Function - blog.enterprisedna.co/discover-unique-insights-using-topn-in-power-bi/
Ranking Insights Using TOPN In Power BI - blog.enterprisedna.co/ranking-insights-using-topn-in-power-bi/
First Purchase Of Customer Insight Using DAX - blog.enterprisedna.co/discover-what-was-the-initial-product-a-customer-purchased-using-dax/
***** Related Course Modules *****
DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Business Analytics Series - portal.enterprisedna.co/p/business-analytics-series
***** Related Support Forum Posts *****
TOPN Bottom Is Blank - forum.enterprisedna.co/t/topn-bottom-is-blank/6571
RANKX Vs TOPN What Is The Difference? - forum.enterprisedna.co/t/rankx-vs-topn-what-is-the-difference/984
TOPN With Multiple Dimensions - forum.enterprisedna.co/t/topn-with-multiple-dimensions/6038
For more TOPN support queries to review see here…. - forum.enterprisedna.co/search?q=topn

[@tayedawa]

Just what I was looking for! I am gonna shine tomorrow! Thank you.

[@EnterpriseDNA]

Wonderful! Goodluck!

[@mnowako]

Excellent! Just to the point! Thanks Sam!

[@antipghosh]

Sir, How to do summation of first 3 numbers in a series in power bi....?
Series: {5, 7, 2,3,9,10,2}
Desired sum: 5+7+2

[@sambolade8280]

Hi Sam. Thanks for the video, I wanted to ask what the Delivery Region is made of as I have not been able to replicate the formula

[@milosnova1011]

Thanks Sam! I have one additional question. Do you have a Dax suggestion when I get an Error: Dax can't work because The table of multiple values was supplied where a single value was expected. If I use Desktops Built in TopN Bottom 1 I get the right answer.
Thank's.

[@Darknesslc3]

that error basically means, in a single cell u produce a table result on it which cannot be displayed, u can only display scalar value in a single cell.

[@williamarthur4801]

Hi, Has anyone noticed a difference in result when using a measure for order by expression as opposed to a column so
EVALUATE
TOPN( 3,
SUMMARIZECOLUMNS( Table1[Item],Table1[Units]),Table1[Units],DESC)
EVALUATE
TOPN(3,
SUMMARIZECOLUMNS( Table1[Item],Table1[Units]),[TopUnits],DESC) // TopUnits = SUMTable1[Units)
Bring back different result, if anyone can recommend vid or blog that deals with this please let me know.

[@NirRobinson]

10x