Count specific words separate by comma on row and exclude empty cells

Hello IoannisT ,

Please change your measure as below:

DoA_Individual_Count = 
IF(MAXX('Table','Table'[Approved_Actions])<>BLANK(),
SUMX(
    'Table',
    LEN('Table'[Approved_Actions])
        -LEN(
            SUBSTITUTE(
                'Table'[Approved_Actions],
                ",",
                ""
             )
        )+1),0)

Output looks as below:

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

Hi IoannisT ,

You can produce your required output in the following manner by tweaking your formula.  

I attach a pbix file as an example.