Calculated Measures based on conditions

[Guest_imported]

Hi
I have a cube that has several measures. A couple of the measures need to be conditional:
ie. Measure1 = sum of orders where prod type = 'abc'
Measure2 = sum of orders where prod type = 'def'

I figure I will have to create calculated measures for this but can't work out the correct statement for the above

IIF(prod type = 'abc', sum orders, 0) does not work ... where am I going wrong?

Thanx

Vamp

 

[djlocke]

Try this:

sum( iif( prod type = 'abc', order_value, 0 ) ) = Measure 1
sum( iif( prod type = 'def', order_value, 0 ) ) = Measure 2