Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX

No comments

Picture this all too familiar scenario….

You are in a meeting and asked, for example, about your sales territories… Who are your top three sales people in each territory? Drilling deeper, what are they selling, when are they selling it and how much?

What if there was a dynamic way to uncover such insights that historically would have been time consuming to find and difficult to drill down into, making you look super professional and organised in the aforementioned meeting situation?

Utilising DAX in Power BI we can in fact dynamically uncover these insights and easily visualize information of this sort. In this video I explain how to construct the key formula needed to achieve this and some reasons why this information might be valuable.

This technique could be used for a range of different applications.  In this example the analysis could be used to recognize and reward the top three salespeople in each region on a monthly basis without the need for complex and time consuming data-collection and analysis that needed to started again as soon as the prior month’s analysis was completed.

Some other uses could include; highlighting your top three customers, your top three products or the three largest cost groups per region.  Ultimately these insights can help you to hone your business strategy around products or regions.

Check out the video below to learn more.

Don’t forget to subscribe to Enterprise DNA TV. New Power BI video every weekday!

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online


***Learn more about Enterprise DNA Membership***membership banner 3

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.