How to do this measure

Anonymous — Sun, 27 Jun 2021 07:44:30 GMT

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

Re: How to do this measure

PaulOlding — Sun, 27 Jun 2021 08:31:18 GMT

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