OR statement

[Anonymous]

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.

[Anonymous]

Thank you @Dangar332 , it is still the same un fortunately. Do you have more ideas, please?

[Dangar332]

hi, @Anonymous 

try 

= 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
  )