Hi Eric, table calculations are limited to the view itself, hence why they cannot be used across multiple sheets and only on the sheet to which they refer. If you have the same dimensions and measures on every view then it would be possible to replicate across sheets but otherwise, this is not really possible,
Sorry, I hope that helps.
When you have the filter on your dashboard with all the sheets you want it to filter on in the view, click the arrow on the filter's layout container. Hover over "Apply to Worksheets" then click "Selected Worksheets..." From there, you'll be able to set up the filter to act on whatever worksheets you select.
I was hoping this wasn't the case but thanks for the response Rob!