Multivariate Bubble Map or Heatmap

I have a dataset with location (zip, lat/long) and a categorical status for each row (Open/Closed.)

I have been through a plethora of stock and third party apps and cannot accomplish being able to convey size/density per location for BOTH variables. Ever since a recent update, default Map visual bubbles are opaque and the bubbles becomes a pie chart when representing multiple variable values. I have also tried Filled Map, Mapbox, and Chloropleth and I can't find a visual that won't summarize the Open/Closed variable.

Ideally, I would like to control the size or density of the bubble/heatmap with the Count and then choose the color or gradient for each value of the variable.