sum order values that contains a specific item

[gianmarco]

Dear All,

i have the following table:

Order number	Item	Value
1	a	12
1	b	15
2	b	15
2	c	20
3	d	11
3	a	12

I need the total order values of the order which contains item "a". 

So my calculated measure shall give back 50 (because it sums all values of order 1 and 3).

Thank you  very much

[johnt75 · Accepted solution]

You can create a measure like

Value all orders = 
var orderIDs = VALUES('Table'[Order number])
return CALCULATE( SUM( 'Table'[Value]), REMOVEFILTERS('Table'), orderIDs )

[gianmarco]

Exactly what I was talking about! Thank you a lot!