Tableau Desktop prevents dashboard filters from affecting the underlying sheets by default. However there is a workaround from the Tableau Knowledge Base that may prove helpful in accomplishing your goal. Take a look at this article:
Hope that helps!
There was a problem with your map viz, I believe this has something to do with your LOD (state/county). To get this working properly for each LOD you could replace your parameter to do a sheet swap for each sheet involved, and the filters will then work.
HTH 10.4 attached with Sheet 6 showing working filter.
Disaster data.twbx 2.8 MB
Thank you for helping Jack and Peter!
I actually managed to figure something out before seeing your answers. The problem seemed to be that in the CASE statement in the calculations, I was setting the fields to NULL in the ELSE statements. After removing the ELSE statements I was able to filter the other sheets based on the map.