Creating conditional measure from different tables

Hello Group, I am very new to PowerBI, trying to migrate some of old excel reports into Power BI, I am stuck with one of the conditional data pull. Here is the UseCase I need to get the data from ...