[BC30201] Expression expected

[Anonymous]

Hi all,

I am trying to run the following expression in POWER BI but I get this error: [BC30201] Expression expected

Here is the expression:

=iif ( Fields!DriftCorrection_pH4Value.Value== Blank(),
(Fields!DriftCorrection_pH7Value.Value +Fields!DriftCorrection_pH10Value.Value)/2.0,
(Fields!DriftCorrection_pH7Value.Value +Fields!DriftCorrection_pH4Value.Value)/2.0)

I appreciate your help in advance,

[Anonymous · Accepted solution]

Hi @samratpbi ,Thanks for the quick reply.

Hi @Anonymous ,

Regarding your question, there may be a problem in checking whether the field value is null or not. You can try to use 'IsNothing' instead of '== BLANK()' for null value determination. Change your expression:
IIF(IsNothing(Fields!DriftCorrection_pH4Value.Value),
(Fields!DriftCorrection_pH7Value.Value + Fields!DriftCorrection_pH10Value.Value) / 2.0,
(Fields!DriftCorrection_pH7Value.Value + Fields!DriftCorrection_pH4Value.Value) / 2.0)

[Anonymous]

Thanks!! this worked! 

[Anonymous]

Hi, Thanks, I did it. unfortunately, it is still the same. 

[samratpbi]

Hi, not sure about all the exact table and column name you have, however what I can see your measure starts with iif. As per my understanding, there is nothing iif, can you please change it to IF.

If this resolves your problem, then please make it as solution, Thanks