Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.