Forum Discussion
Summarize Data for Map Visualization
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 |
Hi,
You do not need to create second table. Just select the aggregate function as Average for Lat and Long
4 Replies
Hi,
You do not need to create second table. Just select the aggregate function as Average for Lat and Long
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.
Nevermind. It's because I had Location in the tool tip. Wow that was much easier than I thought. Thank you!
