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 well for when "exceeds limit" is empty. Thanks!

Red Flag for Overflow = IF(Water[Flow]>Water[ExpectedFlow], "Exceeds Limit", "")
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", "" )
    )

1 Reply

  • 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", "" )
    )