topic Re: OR statement in DAX Commands and Tips

OR statement

Anonymous — Fri, 12 Jan 2024 18:56:05 GMT

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.

Re: OR statement

Dangar332 — Sat, 13 Jan 2024 06:16:47 GMT

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 )

Re: OR statement

Anonymous — Tue, 06 Feb 2024 15:11:31 GMT

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