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.Val...
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
  )