Help! Measure Not Working Correctly

BI_Newbie2 , Try measure with this modification

Health Status =
VAR HealthInd = MAX(DIM_KPI[HealthInd])
VAR Actual = MAX('FACT'[Actual])
VAR Up = MAX('FACT'[Upper])
VAR Low = MAX('FACT'[Lower])
RETURN
IF(
HealthInd = "High" && Actual > Up ||
HealthInd = "Low" && Actual < Low,
"Bad",
"Good"
)

Thanks for the reply from amitchandak.

Hi BI_Newbie2 ,

Is your aim at this stage to get the result that HealthInd is neutral with the “Good” status, if I understand you correctly, I rewrote your arithmetic logic:

NewHealthStatus =
VAR _act =
    SUM ( 'FACT'[Actual] )
VAR _up =
    SUM ( 'FACT'[Upper] )
VAR _down =
    SUM ( 'FACT'[Lower] )
VAR _health =
    MAX ( 'DIM_KPI'[HealthInd] )
RETURN
    IF (
        _act >= _down
            && _act <= _up
            && NOT _health IN { "Low", "High" },
        "Good",
        "Bad"
    )

The result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!