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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NaifO
New Member

How to count particular word in column contains string

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 

1 ACCEPTED SOLUTION
nvprasad
Solution Sage
Solution Sage

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

View solution in original post

3 REPLIES 3
NaifO
New Member

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
Community Champion
Community Champion

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

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

nvprasad
Solution Sage
Solution Sage

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors