Watch The 2023 Update Of This Video Here:
https://youtu.be/lboS4J2QsB8
This is a fantastic technique to discover insights into your data automatically and dynamically that historically would be very time consuming to find. Using CALCULATE and TOPN in combination can enable you to discover immense of amount of insight very quickly.
*****Video Details*****
0:29 - Introduction
2:21 - How To Find Your Top 3 Salespeople
4:17 – Working Out The Formula
5:55 - Calculation Explained
10:30 - Summary
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Using Ranking DAX Measures To Extract Unique Insights In Power BI
https://blog.enterprisedna.co/2018/03/26/using-ranking-dax-measures-to-extract-unique-insights-in-power-bi/
Where Are Your Best Sales By Product? Advanced Analytics with Power BI
https://blog.enterprisedna.co/2019/09/18/ranking-insights-using-topn-in-power-bi/
Discover Your Top Products Per Region in Power BI w/DAX
https://blog.enterprisedna.co/2017/09/06/discover-your-top-products-per-region-in-power-bi-wdax/
***** Related Course Modules *****
Business Analytics Series
http://portal.enterprisedna.co/p/business-analytics-series
Enterprise DNA TV Resources
http://portal.enterprisedna.co/p/enterprise-dna-tv-resources
DAX Formula Deep Dives
http://portal.enterprisedna.co/p/dax-formula-deep-dives
***** Related Support Forums *****
Testing The Pareto Principle (80/20 Rule) in Power BI w/DAX
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
Difference between tables
https://forum.enterprisedna.co/t/difference-between-tables/1653
Filtering Top five client based on some criteria
https://forum.enterprisedna.co/t/filtering-top-five-client-based-on-some-criteria/2666
For more Showing Top 3 queries to review see here…..
https://forum.enterprisedna.co/search?q=showing%20top%203