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...
Негізгі бет When To Use TOPN In Power BI - DAX Formula Review
No video
Пікірлер: 10