Count Non Specific Rows

[Anonymous]

Hi 

I am looking to understand how i can count the number of rows in a column where the string value does not fully match but contains the string specified in the function.

For example, this is one of the cells in my dataset. ["TEN010 - Postcode","TEN008 - Address 5","TEN002 - Name"]. If i wanted to count the row if it contained the word "Postcode" in it, how would i go about doing this as the cell does have the word postcode in it, but it's only a small part of the entrie cell? 

Any advice will be greatly appreciated.

Many thanks 

Nathan

[harshnathani · Accepted solution]

HI @Anonymous ,

Try creating a measure

Contains Postcode = COUNTAX(FILTER('Table', CONTAINSSTRING('Table'[Text], "Postcode")),'Table'[Text])

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Thank you @harshnathani, This worked well!!

[amitchandak]

@Anonymous , Not very clear , you can use search or contains string

Example of column

if(search("Postcode",Table[column1],1,0)>0,1,0)
if(CONTAINSSTRING(Table[column1],"Postcode"),1,0)

Refer : https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/