Help with if statement for different values in other columns

Hi Anonymous ,

According to your description, here's my solution. Create a measure.

Discrepancy found? =
IF (
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Location] = MAX ( 'Table'[Location] )
                && 'Table'[Name] = MAX ( 'Table'[Name] )
                && (
                    'Table'[age] <> MAX ( 'Table'[age] )
                        || 'Table'[income] <> MAX ( 'Table'[income] )
                )
        )
    ) > 0,
    "Yes",
    "No"
)

Get the correct result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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