IF statement using Measures

[M_SBS_6]

Hi, 

I have 2 measures (apps_val and comps_val) of which I need to create a text output on based on the following logic. How would I correctly write this out please? 

If apps_val > comps_val and comps_val > 0 then "uplift" else 

If apps_val < comps_val and apps_val <>0 then "not required" else 

If apps_val > 0 and comps_val is blank then "test"

[Alf94]

Hi @M_SBS_6 ,

You can try the following:

Comparison =
SWITCH(
    TRUE(),
    AND([apps_val] > [comps_val], [comps_val] > 0), "uplift",
    AND([apps_val] < [comps_val], [apps_val] <> 0), "not required",
    AND([apps_val] > 0, ISBLANK([comps_val])), "test"
)

If I answered your question, please mark my post as a solution.

Best,

[ddpl · Accepted solution]

Measure = If([apps_val] > [comps_val] && [comps_val] > 0 , "uplift", 

               If [apps_val] < [comps_val] && [apps_val] <>0 , "not required", 

                     If [apps_val] > 0 && [comps_val] ==BLANK(), "test",0)

[Syndicate_Admin]

Algo igual o similiar a esto:

Salida = if apps_val > comps_val and comps_val > 0 then
"elevar más"
else if apps_val < comps_val and apps_val <> 0 then
"no es necesario"
else if apps_val > 0 and comps_val = null then
"prueba"
else
"otra salida"