topic Re: [BC30201] Expression expected in DAX Commands and Tips

[BC30201] Expression expected

Anonymous — Tue, 19 Mar 2024 18:42:47 GMT

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,

Re: [BC30201] Expression expected

samratpbi — Tue, 19 Mar 2024 21:31:20 GMT

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

Re: [BC30201] Expression expected

Anonymous — Wed, 20 Mar 2024 19:27:32 GMT

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

Re: [BC30201] Expression expected

Anonymous — Mon, 01 Apr 2024 10:09:42 GMT

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)

Re: [BC30201] Expression expected

Anonymous — Wed, 10 Apr 2024 14:29:34 GMT

Thanks!! this worked!