Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

[BC30201] Expression expected

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,

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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)

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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
Not applicable

Thanks!! this worked! 

Anonymous
Not applicable

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

samratpbi
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.