Count a value in multiple columns

Hi, Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Base:

Table:

You may create a calculated column or a measure as below.

Calculated column:

Count Column = 
COUNTROWS(
    FILTER(
        UNION(
            SELECTCOLUMNS(Base,"Option Code 1",Base[Option Code 1]),
            SELECTCOLUMNS(Base,"Option Code 2",Base[Option Code 2]),
            SELECTCOLUMNS(Base,"Option Code 3",Base[Option Code 3])
        ),
        [Option Code 1]=EARLIER('Table'[OPT])
    )
)

Measure:

Count Measure = 
COUNTROWS(
    FILTER(
        UNION(
            SELECTCOLUMNS(Base,"Option Code 1",Base[Option Code 1]),
            SELECTCOLUMNS(Base,"Option Code 2",Base[Option Code 2]),
            SELECTCOLUMNS(Base,"Option Code 3",Base[Option Code 3])
        ),
        [Option Code 1]=SELECTEDVALUE('Table'[OPT])
    )
)

Result:

Best Regard

Allan

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