Summarize Data for Map Visualization

[BrianNeedsHelp]

Our sales territories, are basically a hierarchy of Regions, Subregions, Locations.    So the table has all of the Lats and Longs for each location.  I'm wanting to sum up the sales by each Subregion but not sum up the Lats and Longs.  But keep a random Lat and Long in the subregion, so that the subregions generate on a map.  Is there a DAX code to achieve? 

   E.g.  

Need this:

Sub Region	Location	Latitude	Longitude	Sales
SE	a	29.9645	-90.0885	20
SE	b	30.00944	-90.1634	30
NE	c	30.21084	-90.9219	30
W	d	32.73877	-89.5313	40
W	e	33.06219	-89.5849	50

To Become like this:

Sub Region	Location	Latitude	Longitude	Sales
SE		29.9645	-90.0885	50
NE		30.21084	-90.9219	30
W		33.06219	-89.5849	90

[Ashish_Mathur · Accepted solution]

Hi,

You do not need to create second table.  Just select the aggregate function as Average for Lat and Long

[BrianNeedsHelp]

This shows all the locations.  I'm trying to display only the subregions.  When I put Subregion in the Location and change the Lat and Long to Average, it still shows all the locations.  

[BrianNeedsHelp]

Nevermind.  It's because I had Location in the tool tip.  Wow that was much easier than I thought.  Thank you! 

[Ashish_Mathur]

You are welcome.