DAX: Searching for strings in a text column.

[Andy83]

Hello all, 

I am just curious if there is a way to solve this. I have a text column and I am searching this column using an excel table which is working fine but say one of my keywords is "leg" its returning a true value if someone writes "College" in that free text column. 

Is there a way to say in DAX I only want this string only if there is a space either side of it? 

I hope this makes sense. 

Thank you.

[DataInsights · Accepted solution]

@Andy83,

Here's an example of how you could write it:

Test Measure = 
CALCULATE (
    COUNTROWS ( Table1 ),
    CONTAINSSTRING ( Table1[Column1], " leg" )
        || CONTAINSSTRING ( Table1[Column1], "leg " )
)