Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to do an IF greater than function when cell is not blank

I have this measure that is working well, but when the [Expected Flow] is not calculated for certain areas, the result is still "Exceeds limit". I would like an 'IF NOT BLANK' filter to be added as ...
Need Help
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    Red Flag for Overflow =
    IF (
        ISBLANK ( Water[Flow] ),
        "Exceeds Limit",
        IF ( Water[Flow] > Water[ExpectedFlow], "Exceeds Limit", "" )
    )

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

Red Flag for Overflow =
IF (
    ISBLANK ( Water[Flow] ),
    "Exceeds Limit",
    IF ( Water[Flow] > Water[ExpectedFlow], "Exceeds Limit", "" )
)