SUM using ALLSELECTED from other table

Thank you for your return lbendlin 

I have 4 main tables, as example below: BOM_Table, UnitPrice_Table, Model_Table and Production_Table - also Calendar_Table.

BOM_Table and Production_Table: Fact Table
UnitPrice_Table: It is related to BOM_Table concatenating "Year & Month & Raw Material & Report";
Model_Table:  It is related to BOM_Table and Production_Table by Model column;

Expected outcome:

Multiplying each raw material x cost unit = Total Unit Cost
Then I would like to multiply the Total Unit Cost x Total Family Production from current report and last report, so I can compare the difference between them.

Example, step by step of calculation:

PS: The information that I'm going to use on my dashboard it is just Total Cost Report June and Total Cost Report July

On the example above, I could find the "Total Production" of Family Model A from its related Report (Report July), by using the formula:

CALCULATE(SUM(Production[Qty_Prod]),ALLEXCEPT(Production,Production[Family],Production[Report],Production[Date]))

However, I'm strugling to calculate the "Total Production" of Family Model A from last report.
There are an away to find it? So I can calculate Total Cost Report June using Total Unit Cost Report July?

I hope I could make myself clear.