IF function error

[Edinson]

Help me with this new column

Tip_RQ = IF(Consolidado_RQ[Tipo de Requerimiento] = BLANK(),"Proyecto de Negocio",Consolidado_RQ[Tipo de Requerimiento])

which is the erro here, because when there is no value for Consolidado_RQ[Tipo de Requerimiento], still show (blank).

Pleas help me!

[v-haibl-msft]

@Edinson

Do you have any update about it?

Best Regards,
Herbert

[Edinson]

It doesn´t works. The report still show (Blank) as you can see.

[Vvelarde]

@Edinson

Hi, Let me understand your problem.

You always have TipoRequerimiento  (Data) to every CodigoProyecto. Or they are in different tables?

I think that the blank appears because they are not matching rows with the CodigoProyecto.

What happen if you add a measure CuentaFilas=Countrows(Consolidado_RQ)+0 in a card. What is the result. I think 0.

Let me see what happen.

Regards

Victor

Lima - Peru

[v-haibl-msft]

@Edinson

It seems that the if function works properly on my side. Do you have any sample data can be used to repro your issue? Or you can share your PBIX file through online file service like OneDrive.

Best Regards,
Herbert