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 Colu...
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

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 🙂