How to udentify invoice No. that doesn't include a specific product?

[Maahmohammed]

Dears,

I have some orders, some of them are charged with delivery charge & others are free. We add the delivery charge as an item with a code No. (11), so in case the order is charged with delivery, we add item No. (11) & in case it's free of charge, we don't add that item.

I'd like to have 2 separate tables as per the below:

Data tables

The expected outcome tables are:

[jdbuchanan71 · Accepted solution]

You can write a measure to sum the total price

Total Invoice Cost = SUM ( YourTable[Price] )

Then a mesure to calculate the delivery cost.

Delivery Cost = CALCULATE ( [Total Invoice Cost], YourTable[Procuct_ID] = "11" )

Put those field in the table with the invoice numbers and set the first one to [Delivery Cost] is not blank and the second to [Delivery Cost] is blank