Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Group By Sales rep and Max Count(Area)

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:

 

Simon_BI_0-1613411116829.png

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!

 

1 ACCEPTED SOLUTION
jameszhang0805
Resolver IV
Resolver IV

Hope it's the result you want

jameszhang0805_0-1613465649221.png

 

View solution in original post

3 REPLIES 3
jameszhang0805
Resolver IV
Resolver IV

Hope it's the result you want

jameszhang0805_0-1613465649221.png

 

Anonymous
Not applicable

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?

Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors