1 of 1 people found this helpful
Sorry you've been stumped. Check out this solution:
SUM(IF [Order Type ID] = 1 THEN [Order Header Total Net] ELSE 0 END)
SUM(IF [Order Type ID] = 4 THEN [Order Header Total Net] ELSE 0 END)
Simply we are creating two separate measures with this. Any time the first condition is met, that being its a Sale then we count it as sales or we make the value 0. Then we do the same thing and check if the value is 4 and keep the value if it is and if not we return 0.
Worked perfectly Carl, thanks a lot!