Synchronize axes across multiple worksheets based on filter selections

Hello,

I am trying to show changes in the number of medical providers from 2011 - 2017 by age cohort. I have set up a dashboard that allows comparison of up to three occupations. Based on null and Maximum Scale(Axis) across all work sheets  I created a LOD calculation and added a hidden reference line to set the y-axis limit for each worksheet in the dashboard.

The LOD calculation is: AxisMax = {FIXED [Measure] : MAX({FIXED [Measure], [Occupation] : MAX([Value])})}

This calculates the maximum value for the selected measure (count, percent or per capita). However, it doesn't seem to change based on the 1 - 3 occupations that are selected in the dashboard. This isn't ideal because if I select 3 occupations with a relatively low number of providers, the charts are scrunched down into the bottom of each graph because the axis maximum is set based on the occupation with the highest number of providers in the entire dataset (for the selected measure). For example, in the image below, I've selected three occupations with a relatively low number of providers in each age category. The y-axis limit is set to 126,000 based on the number of social worker (the occupation with the highest number of providers) even though social workers were not one of the occupations I selected.

Is there a way to have the axis update based on the occupation selections that are made in the dashboard? In the example above, the y-axis maximum would be set closer to 30,000 rather than 126,000.

A sample workbook is attached. I am using version 2019.1.6. Thanks in advance for any suggestions you may have.

Ben