Combined columns with unique values into single filter

Hi ndo03001 ,

Please add a condition to the original logic and the overall count will be correct.

Here's the modified formula.

GM1 = 
IF (
    ISFILTERED ( GoalTable[t] ),
    IF (
        MAX ( 'Appended_CCSSE_2015_2019'[GOALAA] ) = SELECTEDVALUE ( GoalTable[t] )
            || MAX ( 'Appended_CCSSE_2015_2019'[GOALCERT] ) = SELECTEDVALUE ( GoalTable[t] )
            || MAX ( 'Appended_CCSSE_2015_2019'[GOALCHGCAR] ) = SELECTEDVALUE ( GoalTable[t] )
            || MAX ( 'Appended_CCSSE_2015_2019'[GOALJOBSKILL] )
                = SELECTEDVALUE ( GoalTable[t] )
            || MAX ( 'Appended_CCSSE_2015_2019'[GOALSELFIMP] ) = SELECTEDVALUE ( GoalTable[t] )
            || MAX ( 'Appended_CCSSE_2015_2019'[GOALTR4YR] ) = SELECTEDVALUE ( GoalTable[t] ),
        1,
        0
    ),
    1
)

The result would be shown as below.

PBIX as attached.

Best Regards,

Jay

Community Support Team _ Jay Wang

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