Dynamic Y-Axis on Stacked Bar Chart?

Hi, you need to get inventive here.
1. Duplicate your original table
2. Group it by Region and Sum of Sales

3. Duplicate the region column, rename it to Location. Add a custom column isregion simply writing 1 

4. Append this table to the original table

5. Then write a calculation: whatever you are counting/displaying there, i took sales as an example

Sales= if(IsFiltered('Table'[Region]), Calculate(Sum('Table'[Sales]), 'Table'[isregion]<>1), Calculate(SUm('Table'[Sales]), 'Table'[isregion]=1))
And here we go

Let me know if you need further explanation