Using master measures in IF statement.

[Architect]

I have 3 master measures.

M_total,

M_app,

M_max.

Now we have to create an if statement that will give us colour output.

If M_total less than M_app colour is green .

And if M_total more than M_app colour is red .

What would be the code?

[MendyS]

Hi @Architect 

try - 

IF(M_total<M_app ,Green(),Red()) 

what do you want to do if M_total is equal to M_app?

[Architect]

Not working.

These are measures, having wrong op

[MendyS]

@Architect 

OK

can you send a screenshot of the error that you got?