When To Use TOPN In Power BI - DAX Formula Review

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

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

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

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