How to count particular word in column contains string

[NaifO]

Greetings all, 

if I would count String in a column that contains a particular word using the measure 

for example, a column contains the full name and I would calculate how many Jeff we have? regardless if is it first or family name 

[NaifO]

if I would count String in a column that contains a particular word using the measure 

for example, a column contains the full name and I would calculate how many Jeff we have? regardless if is it first or family name 

[NaifO]

It worked fine, but could you illustrate why you put number 1 

JeffCount = COUNTX(FILTER('Table',CONTAINSSTRING('Table'[ColumnName],"Jeff")),1)

and thank you for your quick reply

[CNENFRNL]

Reference to COUNTX()

https://docs.microsoft.com/en-us/dax/countx-function-dax

A more robust solution is

= COUNTROWS ( FILTER ( 'Table', CONTAINSSTRING ( 'Table'[ColumnName], "Jeff" ) ) ) + 0

[nvprasad · Accepted solution]

Hi NaifO,

You can get count with the below measure. 🙂

JeffCount = COUNTX(FILTER('Table',CONTAINSSTRING('Table'[ColumnName],"Jeff")),1)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad