Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to do this measure

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's avatar
    PaulOlding
    5 years ago

    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

     

     

PaulOlding's avatar
PaulOlding
Icon for Solution Sage rankSolution Sage
5 years ago

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