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

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