Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Andy83
Frequent Visitor

DAX: Searching for strings in a text column.

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.

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@Andy83,

 

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

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@Andy83,

 

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

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.