topic Re: How to count particular word in column contains string in DAX Commands and Tips

How to count particular word in column contains string

NaifO — Sat, 17 Jul 2021 17:20:32 GMT

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

nvprasad — Sat, 17 Jul 2021 17:41:56 GMT

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

NaifO — Sat, 17 Jul 2021 18:16:13 GMT

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 — Sat, 17 Jul 2021 20:35:54 GMT

Reference to COUNTX()

A more robust solution is

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