Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    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
  )

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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