Forum Discussion

k1ko92's avatar
k1ko92
Regular Visitor
4 years ago
Solved

IF(AND) CONDITICION

Hi all,

 

Someone can help me to improve this IF(AND) ?

 

My formula is considering BLANK() as a 0, when I have BLANK() on column Cumplimiento should return 0.

Column Eval Pendiente = Text

Column Cumplimiento = Number

Column Pontuacion = Number

 

 

 

AND
conditional
DAX
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi k1ko92 ,

    You can change the formula of your calculated column [Pontuacion Disponible] as below, the part with red font is updated ones....

    Pontuacion Disponible =
    IF (
    ISBLANK ( 'UNPIVOT KPI'[Cumplimiento] ),
    0,
    IF (
    AND ( 'UNPIVOT KPI'[Eval Pendiente] <> "", 'UNPIVOT KPI'[Cumplimiento] = 0 ),
    'UNPIVOT KPI'[Pontuacion] * 1,
    0
    )
    )

    Best Regards

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Hey, not sure exactly what you are trying to do but maybe this will help. These are the rules:
    " " = BLANK ()  => TRUE
    " " == BLANK ()  => FALSE
    0 = BLANK ()  => TRUE
    0 == BLANK ()  => FALSE

    In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi k1ko92 ,

    You can change the formula of your calculated column [Pontuacion Disponible] as below, the part with red font is updated ones....

    Pontuacion Disponible =
    IF (
    ISBLANK ( 'UNPIVOT KPI'[Cumplimiento] ),
    0,
    IF (
    AND ( 'UNPIVOT KPI'[Eval Pendiente] <> "", 'UNPIVOT KPI'[Cumplimiento] = 0 ),
    'UNPIVOT KPI'[Pontuacion] * 1,
    0
    )
    )

    Best Regards