Cannot figure out the error in this formula with multiple IF conditions

[ksab23]

Hi, long story short I need a formula for curriculum completion. I would like to have a calculated column, with status complete/incomplete or 1/0.

The logic for completion is as follows:
Part 1 - Mandatory courses: N12, N13, N14
Part 2 - Any 2 out of 6 courses need to be completed: N6,N7,N8,N9,N10,N11

Completion= IF(

        'User List'[N12] >= 1 &&

        'User List'[N13] >= 1 &&

        'User List'[N14]>=1 &&

        (

            IF(

            SUMX(

                VALUES('User List'),

                'User List'[N6] +

                'User List'[N7] +

                'User List'[N8] +

                'User List'[SN9] +

                'User List'[N10] +

                'User List'[SN11]

            ) >=2, 1, 0

        )

    ) >=1, 1,0)

Thanks for any suggestions!

[ppm1]

Not sure what additional analyses you have planned, but you should consider unpivoting your course columns and using a measure instead of a column.

If not, please try this column expression.

Completion =
IF (
    'User List'[N12] >= 1
        && 'User List'[N13] >= 1
        && 'User List'[N14] >= 1
        && ( 'User List'[N6] + 'User List'[N7] + 'User List'[N8] + 'User List'[SN9] + 'User List'[N10] + 'User List'[SN11] ) >= 2,
    1,
    0
)

Pat