topic Group By Sales rep and Max Count(Area) in DAX Commands and Tips

Group By Sales rep and Max Count(Area)

Anonymous — Mon, 15 Feb 2021 17:46:52 GMT

Hi Everyone,

I need your help regarding the following problem:

I have a table with sales, sales reps and area.

Now I want to group my Sales reps into a new table with the Area with the highest count also included.

Below what I want to achieve:

As you can see Sales rep A has done most of his sales in EU so his Main Area is EU.

Thanks for the help!

Re: Group By Sales rep and Max Count(Area)

Anonymous — Mon, 15 Feb 2021 18:05:44 GMT

What happens if there is a rep that has at least 2 different areas with the same counts? Which area do you want to return?

Re: Group By Sales rep and Max Count(Area)

Anonymous — Mon, 15 Feb 2021 18:50:41 GMT

Thanks for your reply!

This is not going to happen (or at least it shouldn't) because they sell in 1 main area and only in rare occasions they can have a sale in another area.

Re: Group By Sales rep and Max Count(Area)

jameszhang0805 — Tue, 16 Feb 2021 08:54:19 GMT

Hope it's the result you want