zipcode heat map with multiple values

Hi patrickoleary85 ,

If I understand correctly, the issue is that you want to display the count of zipcodes for two tables on the same map. Please try the following methods and check if they can solve your problem:

1.You need to create a relationship between two tables on the zip code column.

2.Using DAX to create a new table that aggregates the counts of Clients and Staff by zip code.

3.Select the map visualization. Drag the zip code field into the Location area. Drag the count field to the size area. Drag the Type field into the Legend area.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format or screenshot to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your reply.

Best Regards,

Wisdom Wu