Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hope it's the result you want
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |