Help with IF Statement Measure that uses AND and OR

Hi Anonymous ,

You can refer to the DAX below:

Y =
IF (
    MAX ( 'Table'[Concerns] ) = "Y"
        && (
            NOT ( MAX ( 'Table'[Reason 1] ) = "" )
                || NOT ( MAX ( 'Table'[Reason 2] ) = "" )
                || NOT ( MAX ( 'Table'[Reason 3] ) = "" )
        ),
    1,
    IF (
        MAX ( 'Table'[Concerns] ) = "N"
            && MAX ( 'Table'[Reason 1] ) = ""
            && MAX ( 'Table'[Reason 2] ) = ""
            && MAX ( 'Table'[Reason 3] ) = "",
        1
    )
)

If I misunderstood, please provide the result you expect.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.