Dynamic filtering for related sub data

Here goes...this is my first post on the forum so please forgive any missed etiquette. I hope I can explain this as best as humanly possible.

Goal: Multi-Category Filters in table 1 are reflected in the aggregated summary average for the same category in table 2.

Step 1: 

• To start I have 2 tables Table 1 is a survey result with all respondents along with their calculated scores (Elements 1-3)
• Table 2 is a list of Identities that have elements 1-3 scores almost like a personality score.  and acts as a reference table, however, the brand is not natively a part of table 2. This is where I'm am having the challenge.
• For me to perform the calculations I need, I had to create a calculated table using the Summarize DAX function (table 3) that averages elements 1-3 and gives me a summarized total for each brand in table 1.

• I then use the Generageall DAX function to bring together table 3 summary into table 2 so that I can have the brand summary scores now a part of table 2 identity in a new combined table (let's call it table 2.2)
•  
• The problem that is I can't seem to fix is that Table 3 Averages all 3 elements from Table 1  however it is not responsive to any filters in table 1. For example, if I would like to filter on question 1 and have the updated values recalculated and reflected back on table 2 but it does not update based on the filter it just gives me the same summarized calculation as before but I need it to be dynamic so that I can apply various filters in my visuals for the proper display.

I literally do not have the mental know-how ohn how to achieve this and I have been trying for the last 6 days and am just about ready to give up so any assistance you can provide would be greatly appreciated.

Thanks,

Sean