count occurrences in COLUMN AS STRINGS WITH DAX

[Aadil_Sharma_Ma]

Hi all, please help to count the websites repeatance in the column , i want the count in each record like how many times the word website is repeated with the help of dax.

[tamerj1 · Accepted solution]

Hi @Aadil_Sharma_Ma 

please try

Count =
COALESCE ( PATHLENGTH ( SUBSTITUTE ( 'Table'[Names], "'", "|" ) ), 0 )

[Aadil_Sharma_Ma]

THIS IS GIVING THIS RESULT ITS STILL UNABLE TO COUNT THE REPEATANCE OF WEBSITES STRING IN A SINGLE ROW

[tamerj1 · Accepted solution]

Hi @Aadil_Sharma_Ma 

please try

Count =
COALESCE ( PATHLENGTH ( SUBSTITUTE ( 'Table'[Names], "'", "|" ) ), 0 )

[Aadil_Sharma_Ma · Accepted solution]

A LITTLE ERROR FIND IN THE DAX CODE , UNDER THE SUBSTITUE WE HAVE TO USE THE ","  THIS , NOT THIS "'" = THIS UNABLE TO COUNT IT BTW THANKS A LOT ITS A EFFECTIVE SOLUTION.

[tamerj1]

@Aadil_Sharma_Ma 
Yes you are right. That was a typo mistake, I was typing on my phone last night.