topic Re: Issue with if in DAX in DAX Commands and Tips

Issue with if in DAX

Vanessa250919 — Thu, 16 Sep 2021 19:09:06 GMT

Hello all,
I have one question/Issue with DAX in statement IF

I try to make a flag, but if i used < my data is empty ... I don't know why...

Check my print screen

Re: Issue with if in DAX

Anonymous — Thu, 16 Sep 2021 19:59:01 GMT

Hey,

the IF-Function is defined like this: IF(<logical_test>, <value_if_true>, <value_if_false>)

If I see it correctly, you missed the "else" statement.

Regards

Re: Issue with if in DAX

Vanessa250919 — Thu, 16 Sep 2021 20:08:20 GMT

Anonymous it's same ...

Re: Issue with if in DAX

Anonymous — Thu, 16 Sep 2021 20:45:00 GMT

hmmm... but if you don't inserte the measure there is data displayed?

What does the [Med%] measure do?

Re: Issue with if in DAX

VahidDM — Thu, 16 Sep 2021 21:47:36 GMT

Vanessa250919

Try this:

AmountPrime=
Var _A = 120%
return
if([Med%]<_A,"Yes","False")

If it does not work, can you share a [Med%] measure code here?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

Re: Issue with if in DAX

Vanessa250919 — Fri, 17 Sep 2021 04:47:43 GMT

VahidDM

not ...

Med% =

VAR __BASELINE_VALUE = SUM('V_FACT_TMA_EOY_REFERENCE'[MED_ALL])

VAR __VALUE_TO_COMPARE = [Currents ALL]

RETURN

IF(

NOT ISBLANK(__VALUE_TO_COMPARE),

DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

+1)

Re: Issue with if in DAX

Vanessa250919 — Fri, 17 Sep 2021 04:47:58 GMT

Anonymous

Med% =

VAR __BASELINE_VALUE = SUM('V_FACT_TMA_EOY_REFERENCE'[MED_ALL])

VAR __VALUE_TO_COMPARE = [Currents ALL]

RETURN

IF(

NOT ISBLANK(__VALUE_TO_COMPARE),

DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

+1)

Re: Issue with if in DAX

Anonymous — Fri, 17 Sep 2021 18:52:28 GMT

Last guess...

if( Ref <> blank() && Curr <> blank() && ([Med%]<1.2), "yes", "no")

Because I don't understand why there is no data displayed ;D

Regards