DAX Calculated Column Sum with Two Categories

[Alfista1997]

I'm trying to create a column in table 1, that refrences table 2 and sum the values in Column 1 for each ID and Year-Month and divide that by the sum of values in Column 2 for each ID and Year-Month and have that result populate into my other table. 

If I've got 2 IDs 17964 and 54008 with a table like this, but there's a lot more columns of course. Then Table 2 looks like below, there is no data for 17964, so techically it should return blank/0. The new column in table one should return 0 and 0 for 17964, and 282% and 266% for 54008 for each of their respective yr-month and id.

Table 1

ID	Year-Month
17964	202306
17964	202305
54008	202306
54008	202305

Table 2

  Yr-M        ID        Colm. 1     Colm. 2       Ignore/DateField

202305	54008	31007.45	5513.61	Monday, May 1, 2023
202305	54008	16819.55	7053.2	Monday, May 1, 2023
202305	54008	0	4375.85	Monday, May 1, 2023
202306	54008	31007.45	5719.69	Thursday, June 1, 2023
202306	54008	16819.55	7135.67	Thursday, June 1, 2023
202306	54008	0	5115.12	Thursday, June 1, 2023

[amitchandak]

@Alfista1997 , to create a column in table using another table

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8