Postal code Map - Combining groups of postal codes

[Anonymous]

Hi all,

I'm trying to create a map visual based on US DMA codes, here's info on what dma's are. It's litteraly a group of postal codes that are identified as one area. 

I'm trying to create a map visual that shows e.g. sales by DMA, so all postal codes per DMA will have one total sales value and need to be grouped. Like you see below.

Any instructions how to do this?

Thanks!

[mh2587]

Did you have DMA table in your model and related to sale table ?

[Anonymous]

Yes, I have a file that maps postal code to DMA and the sales information is availabe by DMA.