Need to count number rows that have two specific values in the same column

[MEFOX]

I need to count the number off rows that have both "friend" and "foe" in the first column. I've tried to use the DAX containsstring function but I'm not having much success. Does anyone have a suggestion?

An example would be below. I would expect the count to be 2.

Mike is a friend and foe
Jane is a friend
Candy is a friend but sometime is also a foe

[lokosrio · Accepted solution]

Please try with:

COUNTROWS (
    FILTER (
        table_name,
        CONTAINSSTRING ( table_name[column_name], "friend" ) &&
        CONTAINSSTRING ( table_name[column_name], "foe" )
    )
)