Measure to Sum Revenue between two tables with multiple conditions

I have two tables, where one table has customer scores by month and categories and the other one with monthly revenue. Majority of my visuals are using the second table, and I would like to create a scatter plot graph that shows the distribution of revenue and scores. To do this, I have to match the two tables via account ID and month. Because of the categories in table 1, IDs and Month's repeat, thus I cannot use a LOOKUPVALUE. I tried creating measures with filters but they didn't work either. Below are my two tables:

Table 1:

Table 2:

I also tried creating a temporary table within my measure that summarizes table 1 into ID and Month, but that didn't work either. How can I create a measure that links both of these tables together so I can see the distribution of revenue and scores on an ID level?