topic IF(AND) CONDITICION in DAX Commands and Tips

IF(AND) CONDITICION

k1ko92 — Thu, 05 May 2022 15:46:59 GMT

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

Re: IF(AND) CONDITICION

SpartaBI — Thu, 05 May 2022 16:16:07 GMT

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 🙂

Re: IF(AND) CONDITICION

Anonymous — Tue, 10 May 2022 07:57:30 GMT

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] ),

IF (

AND ( 'UNPIVOT KPI'[Eval Pendiente] <> "", 'UNPIVOT KPI'[Cumplimiento] = 0 ),

'UNPIVOT KPI'[Pontuacion] * 1,

)

Best Regards