Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PeterWu
Frequent Visitor

How to do this measure

PeterWu_0-1624779783939.png

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

 

PeterWu_1-1624779861945.png

 

1 ACCEPTED SOLUTION
PaulOlding
Solution Sage
Solution Sage

Set a relationship between the tables on Chassis PN like so

PaulOlding_0-1624782148356.png

 

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_1-1624782371909.png

 

PaulOlding_2-1624782457476.png

 

View solution in original post

1 REPLY 1
PaulOlding
Solution Sage
Solution Sage

Set a relationship between the tables on Chassis PN like so

PaulOlding_0-1624782148356.png

 

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_1-1624782371909.png

 

PaulOlding_2-1624782457476.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors