Comparing Multiple Dimensions in Data Item using MDX

[LFC]

Hi All,

I am trying to write a MDX expression to replicate a relational Case statement.

the below is the Case statement which i have been trying to replicate using MDX, the STATE and PRODUCT are in two seperate dimensions of their own.

case
when STATE = 'FL' and PRODUCT IN ( '284', '257' , '342' )  THEN ( 0 )
when  STATE = 'VA' and PRODUCT = '554'  THEN ( 0 )
else AMOUNT
end

any suggestions would be greatly appreciated.