How to do this measure

Question

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&nbsp;&nbsp;

paulolding · Accepted Answer

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

Forum Discussion