Database design for comparing rows

Hi Benjamin_Eureka,

Is the output in your data your expected output? But as parry2k said, the data you provided lack candidate column. Would you please check for it?

If you want to filter out candidate that pass both Exam A and Exam B, please refer to the measure below:

Measure =

VAR A =

    CALCULATE (

        MAX ( 'Table'[result] ),

        ALLEXCEPT ( 'Table', 'Table'[candidate] ),

        'Table'[exam] = "ExamA"

    )

VAR B =

    CALCULATE (

        MAX ( 'Table'[result] ),

        ALLEXCEPT ( 'Table', 'Table'[candidate] ),

        'Table'[exam] = "ExamB"

    )

RETURN

    IF ( A = "Yes" && B = "Yes", 1, 0 )

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

Best Regards,

Dedmon Dai