Filters

[tjeffries]

Hi Everyone,

I know this is probably really simple but I've been struggling with it for the last two hours - I need to filter out the blue orders out of the first table then filter out the red shipments from the second.   then subtract the red orders from the blue shipments.  I've tried to filter the values but it never works.  any assistance would be appreciated

Orders			Shipment
Red	10		Blue	50
Blue	20		Red	40
Red	30		Blue	30
Blue	40		Red	20
Red	50		Blue	10
Blue	10		Red	50
Red	20		Blue	40
Blue	30		Red	30
Red	40		Blue	20
Blue	50		Red	10

[az38 · Accepted solution]

Hi @tjeffries 

try a measure

Measure =
CALCULATE(SUM('Shipment'[Value]), 'Shipment'[Colour] = "Blue") - 
CALCULATE(SUM('Orders'[Value]), 'Orders'[Colour] = "Red")