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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
sebasjun
Helper I
Helper I

Summarize By 2 groups

Hello

 

I can try to put in a filled map the best customer.

 

My table is:

 

Country-Customer-Total Sales

Canada-Customer1-100

Canada-Customer2-200

Canada-Customer3-400

USA-Customer2-1000

USA-Customer4-5000

....

 

In the filled map show:

In canada Customer 1 

In USA - Customer 2

 

But not is the best custoemer

 

I can try to use a summarize table, but not work

 

Any ideas?

 

Thanks

 

 

 

2 REPLIES 2
Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi @sebasjun

 

So are you trying to show the customer for each country that has the most sales?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hello

 

I reviewed few months an blog and i think is an absurd question

 

Thanks

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.