Count Multiple Choice Text field occurrences from Multiple Columns.

Hi  RooneyHat ,

You could try the following steps:

Step 1,create a slicer table:

Step 2,use the following measure on base table:

sum = 
CALCULATE (
    COUNT ( 'Table'[Objective Choice 1] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Objective Choice 1] = SELECTEDVALUE ( Slicer[Color] )
    )
)
    + CALCULATE (
        COUNT ( 'Table'[Objective Choice 2] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Objective Choice 2] = SELECTEDVALUE ( Slicer[Color] )
        )
    )
    + CALCULATE (
        COUNT ( 'Table'[Objective Choice 3] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Objective Choice 3] = SELECTEDVALUE ( Slicer[Color] )
        )
    )
    + CALCULATE (
        COUNT ( 'Table'[Objective Choice 4] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Objective Choice 4] = SELECTEDVALUE ( Slicer[Color] )
        )
    )
    + CALCULATE (
        COUNT ( 'Table'[Objective Choice 5] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Objective Choice 5] = SELECTEDVALUE ( Slicer[Color] )
        )
    )

Then create visualization:

You could download my pbix file to learn more details,wish it is helpful for you!

Best Regards

Lucien