Find Your Top 3 Salespeople Per Region Automatically in Power BI using DAX

[@EnterpriseDNA]

***** Related Links ***** Using Ranking DAX Measures To Extract Unique Insights In Power BI 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 blog.enterprisedna.co/2019/09/18/ranking-insights-using-topn-in-power-bi/ Discover Your Top Products Per Region in Power BI w/DAX blog.enterprisedna.co/2017/09/06/discover-your-top-products-per-region-in-power-bi-wdax/ ***** Related Course Modules ***** Business Analytics Series portal.enterprisedna.co/p/business-analytics-series Enterprise DNA TV Resources portal.enterprisedna.co/p/enterprise-dna-tv-resources DAX Formula Deep Dives portal.enterprisedna.co/p/dax-formula-deep-dives ***** Related Support Forums ***** Testing The Pareto Principle (80/20 Rule) in Power BI w/DAX forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459 Difference between tables forum.enterprisedna.co/t/difference-between-tables/1653 Filtering Top five client based on some criteria forum.enterprisedna.co/t/filtering-top-five-client-based-on-some-criteria/2666 For more Showing Top 3 queries to review see here….. forum.enterprisedna.co/search?q=showing%20top%203

[@rauljimenez5485]

I find that I re-watch your videos at least once a month. Each time a find another layer of insight that I hadn´t grasped prior. Your videos are genius in their simplicity, elegance and most importantly, their usefulness!! Thank you very much for sharing!

[@paulanunez7295]

I've been trying to do this for the past 3+ hours. Thank you a so much for this!!

[@MarkCBB86]

That is a really cool Video - Easy to follow - Thank you

[@seankelly573]

This is super helpful! I'm stuck on how to find the bottom three though. Anything to help me get unstuck would be great.

[@abhijeetghosh27]

Though my requirement was a bit different but this video helped me a lot. Thanks #EnterpriseDNA and #SamMackay 👍👍

[@sardines4dinner]

Is it mentioned anywhere how to get the measure for [Total Sales]? like what's the formula? Thanks

[@EnterpriseDNA]

Hi Bhavesh, thanks for posting your comment in the video. All pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks! portal.enterprisedna.co/

[@adriannacook313]

Hi Sam, thanks for another great video! I was hoping you would be able to show a step further to rank another layer in the hierarchy. For example, I would like to find out top 5 of regions, then inside top 5 of regions, I need to find out top 1 salesperson; after that I would like to find out top 1 product sold by that sales person. Could you please show me how I can do this? Thank you so much.

[@EnterpriseDNA]

Hello Adrianna, Thank You for posting your query onto our channel. Appreciate your terrific question here but for now we're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZbin channel pertaining to this topic about the ranking which covers different types of scenarios. Also please feel free to browse the videos over our KZbin channel. 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. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA blog.enterprisedna.co/dynamic-ranking-tables-in-power-bi/ blog.enterprisedna.co/showcasing-top-or-bottom-results-using-ranking-techniques/ kzbin.info/www/bejne/fnvHh5mPoMubo6c kzbin.info/www/bejne/eajFeaymhtJ1sJI kzbin.info/www/bejne/fZixZp-th7qUp8U kzbin.info/www/bejne/nomQpGSeqaeXo80 kzbin.info/www/bejne/f4asYoBufbaYpMU

[@inigosagues1180]

Sam thanks for sharing your insights, could you please tell me if it is possible to have a slicer with the options 1) “year” and 2) “months” options, in order to get the top 3 products per year if only the year option is selected (RANKX filtering just by year) or top 3 products per year AND per quarter if both are selected (RANKX filtering by year and month)?

[@EnterpriseDNA]

Hi iñigo, Thanks for your comment. Yes, this is very much possible inside Power BI. You may need to use ISFiltered function or similar DAX function. For additional info, you may explore the Enterprise DNA Forum for discussions similar to this one. Also, explore info.enterprisedna.co/dax-guide/dax-function-guide/ for information on DAX functions.

[@GTVRBV]

Hi Sam, thanks for all your terrific videos. I love it. You do an awesome job in regards to how to implement power bi. I also purchased one of your courses. Great material. I have a question. Do you also have videos/explainations about the Datea Gateways within Power BI Services so that data will be updated on a specific schedule? Would be great to get some ideas from you. Regards Gunther from Germany.

[@EnterpriseDNA]

Hi Gunther, that's great. At the moment I don't have anything specific on that. I will make some updates to the Power BI Super Users Workshop course shortly around setup there. The main focus is more on the analytical side of Power BI, but I will make sure to cover those in more detail as a few have been asking. Chrs

[@estebanvalenzuela4148]

Hi Sam, First of all, thanks for your content. Now, can you help me with: ¿How about a LAST 3 list by category? thanks!

[@EnterpriseDNA]

All you need to do there is slight adjustments to the same technique and just chance the initial context of the calculation

[@911everest]

Great Tip. I'm looking to get the salesperson name concatenated with the value for use in a card. I have stumbled a little here. Can anyone help?

[@EnterpriseDNA]

Hi Michael, for help like this check out the Enterprise DNA Support Forum - forum.enterprisedna.co/search?q=concatenated

[@nalipapaiah8384]

could you please provide me the link of sample data used in this report

[@EnterpriseDNA]

Please review the description

[@radhikamaheshwari4835]

Hi, this is an amazing way to dynamically show values. I have tried to use this measure for olympics data to find out the top 10 athletes with highest medals but it didn't work for me. This was because there were a lot of athletes having won same number of medals and created duplicate ranks in it and if choose to show top 10 values then more than 10 athletes were in the list due to multiple athletes having won the same number of medals hence the same rank. How to edit this measure so that when the total of the expression used is same for multiple rows then correct number of results are shown?

[@EnterpriseDNA]

Hello radhika maheshwari, Thank you for posting your query onto our channel. We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZbin channel pertaining to this topic where we've showcased about how to break ties. 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. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA blog.enterprisedna.co/rankx-in-power-bi-developing-custom-tiebreakers/ forum.enterprisedna.co/t/rank-unique-ranking-when-there-are-duplicate-values/2815 kzbin.info/www/bejne/fpy1Yn2Mr9KpiNk kzbin.info/www/bejne/Z5jMp6KpgrGbeas

[@chandankumar8308]

I found top 3 items helping with DAX (SUMX(TOPN(3, 'sale record' , 'sales record ' [ item], ASC), 'sale record ' [total revenue ]) But answer (total sum) is mismatch kindly solve this question

[@EnterpriseDNA]

Hello Chandan, Thank You for posting your query onto our channel. There are several videos created which addresses this type of problem and provides the solution to it. Below are the links provided of the videos for the reference created on this topic - 1. Getting Totals Correct When Using Advanced Logic - Power BI & DAX - kzbin.info/www/bejne/amW0hp13arN3rbs 2. Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand - kzbin.info/www/bejne/iJrMkGmnoLGBnpo 3. Fixing Complex Total Errors - DAX Formula Concepts - kzbin.info/www/bejne/hpPOiJ6vgNl0e9k 4. How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts - kzbin.info/www/bejne/h5ypnYxvl6qiqqs Also providing below a link of the post created on our Enterprise DNA Community Forum for the reference - Fix Incorrect Totals - forum.enterprisedna.co/t/fix-incorrect-totals/8834 Hoping you find this useful and helps you to achieve the desired analysis that you're looking for.🙂 Thanks and Warm Regards, Enterprise DNA

[@hamzarafique3857]

But what if I want to use a percentage instead of a whole number like 3?

[@EnterpriseDNA]

Just change the internal parameters inside the formula. You'll have to make some adjustments but the pattern should be the same