Set Analysis using Multiple If Statements

[Mahajan]

Hi,

Can anyone help me  to write below expression using Set Expression :

=If(Status='Imported','Not Available', If(Sum(Price)<>0,Sum(Price), If(Sum(Cprice)<>0,Sum(Cprice),If(Sum(Dprice)<>0,Sum(Dprice),sum([Dummy Price])))))

Thanks

[treysmithdev]

Your expression is conditional. I do not think you can replace what you are doing leveraging Set Analysis. You could do that if you were defining your selection criteria using IF statements, but you are changing the expression itself.

Also, note that Set Analysis happens before the dimensionality so if won't change the data by the dimension value's result (Ex: Sum(Price)<>0). 

Your best case scenario is to modify your data model to accomodate this logic.