Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please find my expected result below
But I am getting result as below
where I have choosed Order Id from orders table and Product Id from Order Items tables and I have used below measure
I have a datamodel as shown below
I have given a relationship as shown blow
It has been created as shown below where From Table is Order Items and To Table is orders whereas while creating I have given orders as From Table and Order Items as To Table
Solved! Go to Solution.
Hi, @sheetals
You can try the following methods.
order_to_orderitem =
IF (
MAX ( 'orders'[Product ID] ) == BLANK (),
BLANK (),
CALCULATE (
SUM ( 'Order Items'[Unit Price] ),
USERELATIONSHIP ( orders[key12], 'Order Items'[key12] )
)
)
If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @sheetals
You can try the following methods.
order_to_orderitem =
IF (
MAX ( 'orders'[Product ID] ) == BLANK (),
BLANK (),
CALCULATE (
SUM ( 'Order Items'[Unit Price] ),
USERELATIONSHIP ( orders[key12], 'Order Items'[key12] )
)
)
If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.