Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
5 years ago

Issue with if in DAX

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

 

 

Need Help
Need Help DAX

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

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

        What does the [Med%] measure do? 

         

         

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    5 years ago

    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✌️!!



    • Vanessa250919's avatar
      Vanessa250919
      Icon for Helper V rankHelper V
      5 years ago

      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)