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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s