Creating unique value column based on two filters

Hello all!

I have what I believe to be a straight forward problem but really struggling with the solution.

I want to get the number of active (open) franchises in a region and create a new column with that information.  I can do this is Python relatively easy but I'm trying to do as much in PowerBI/DAX as I can. So for example, a sample table (Table1) is below:

I have another table that has as many rows as their are regions - in this case lets assume I have the three regions listed. So what I want to do is filter based on the unique regions and then count the number of entries in that filtered region that are == "Yes".  (Get the number of active franchises in each region).

ActiveFranchisesPerRegion = CALCULATE(COUNTA('Table1'[Open]), FILTER('Table1', DISTINCT('Table1'[Region]) ))

However I'm getting the error: 'A table of multiple values was supplied where a single value was expected'.  I'm not surprised to get the error as I know the code and filters are not right.  

My expected result would be:

Can anyone help to set up my filters/code in the right way to help address this problem?

fdasfasf