Using a filter to filter two different tables

I have a table which forecasts the units of each model that will be sold and a separate table which forecasts the volume of each model that will be sold. I also have a table which is much more complex and gives a detailed breakdown of all the products sold according to a specific region and customer and as well model. This table includes alot more models than the former table since the former tables only forecast for a particular category of models.

My first two tables look like this:

REGION Fin PRODUCT FY20 BUDGET

1 X

1 Y

1 Z

2 X

2 Y

2 Z

3 X

3 Y

3 Z

REGION Model FY20 Units

1 X

1 Y

1 Z

2 X

2 Y

2 Z

3 X

3 Y

3 Z

The other table(which details our actuals),a breakdown of the product and its parts sold but it has a region and a model column which does coincide with the columns from the previous table, although it has a greater variety of models than that of the previous table.

I'm using a clustered column chart to compare the actuals vs the forecast and i want to have a model filter. I've tried to create a R/S between the three tables but only one of the columns managed to get filtered by the model filter. Is it possible for a model filter to work on both columns.

This is the relationship I have so far.

1 and 2 is the forecast in units and in volume whereas 3 is the detailed breakdown of our sales/actuals.