Showing unexpected values in Power BI charts

[sheetals]

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 

order_to_orderitem = CALCULATE(SUM('Order Items'[Unit Price]),USERELATIONSHIP(orders[key12],'Order Items'[key12]))

Note: key12 is merged column of Order Id and Product Id in both orders and Order Items table

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

[v-zhangti · Accepted 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.