topic Using master measures in IF statement. in Connectivity & Data Prep

Using master measures in IF statement.

Architect — Mon, 31 Oct 2022 09:42:12 GMT

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 — Mon, 31 Oct 2022 09:51:57 GMT

try -

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

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

Architect — Mon, 31 Oct 2022 11:16:39 GMT

Not working.

These are measures, having wrong op

MendyS — Mon, 31 Oct 2022 12:25:06 GMT

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