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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Anonymous
Not applicable

OR statement

Hi every one,

 

I am trying to run this iif in DAX, but I get an error:

 

= iif (OR( [StationName.Value] = "CONGbann01", [StationName.Value] = "CONGccbr01"),

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

 Here is the error:

 

The Value expression for the textrun 'DriftCorrection_pH7Value1.Paragraphs[0].TextRuns[0]' contains an error: [BC30201] Expression expected.

 

Also, I included 2 pictures of the variables (circled in red) I am using.