Get the cost based on category in different table

[zzzsharepoint]

I have tables like this:

Project	Category	Cost
A	CPU	123
A	Network	222
B	CPU	221

Then I have another two table which is for CPU and Network like this: Table for CPU

Project	Region1_CPU Value	Region2_CPU Value
A	0.5	0.5
B	0.2	0.8
C	0.3	0.7

same I have for Network:

Project	Region1_Network Value	Region2_Network Value
A	0.3	0.7
B	0.2	0.8
C	0.3	0.7

Now I need to show the visual for each project where I determine the cost of CPU and Network for Region 1 and Region 2.  Basically I need to calculate Cost ie. and the formulae for that is:

Project A:
CPU cost from Table 1 for Project A is 123 so for Region 1 and Region 2 it is 0.5*123 and 0.5*123 and Network cost is 222*0.3 for region1 and 222*0.7 for region2. same way for other project. Can anyone please guide how can I do this.

Thanks

[ChrisMendoza]

@zzzsharepoint - I'll be interested to see what others come up with. I created 6 measures in total (3 for each case; CPU case shown). PBIX attached.