How to do this measure

[Anonymous]

I have a data set look like this, How can I get the PCA Demand from Chassis demand to for DAX? and build I a table like below sample

[PaulOlding · Accepted solution]

Set a relationship between the tables on Chassis PN like so

You don't explicitly say this in your post but the only way I could get to your figures was to multiply Qty by Demand.  Is that what you want?  

Here's a measure that does that:

Demand Measure =

SUMX(Chassis, Chassis[Demand] * RELATED(PCA[Qty]))

Then you can create this matrix