Power BI, IF statement with OR in DAX (1 Viewer)

[elikab92]

Hi everyone!

I am trying to run this query in DAX in PowerBI:

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


But I get this error:

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

Could you please help? Thanks in advance!

 

[theDBguy]

Is DriftCorrection_pH7Value a calculated column? Just curious...

 

[elikab92]

Thanks for your response, since I don't exactly know what calculated column means, I just added a picture of what I am trying to calculate (PH= expression) in the body of my post. Could you please check it again? Thanks