Reference to self Error in Master Measures

[zhaokuifangmm]

Hi all, 

I have a master measure with the following formula:

If(Present >= 20, 'Good', If(Present >= 10, 'Medium', 'Bad'))

This formula used to work fine. However, when I checked this report I found that this field does not work anymore.

In the edit mode I got the following error message:

Reference to self

As I understood I cannot use the same reference in the else clause. Does anybody knows why it used to work but not now? Is there any other way to write this formula? Many thanks!

[sfbi]

I'm getting the same here in a two condition if measure... never saw this kind of error.

[harm_dataspark]

I'm experiencing the same issue. It looks like you cannot use the same master measure more than once in an expression. 

[sfbi]

@harm_dataspark yes... in my case I was using if(MasterMeasure1 > 0 and MasterMeasure1 < 2, x, y)...

I solved writing down the expression it self inside the if statement.