topic Re: count occurrences in COLUMN AS STRINGS WITH DAX in DAX Commands and Tips

count occurrences in COLUMN AS STRINGS WITH DAX

Aadil_Sharma_Ma — Tue, 25 Apr 2023 17:20:36 GMT

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.

Re: count occurrences in COLUMN AS STRINGS WITH DAX

tamerj1 — Mon, 24 Apr 2023 18:39:13 GMT

Hi Aadil_Sharma_Ma

please try

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

Re: count occurrences in COLUMN AS STRINGS WITH DAX

Aadil_Sharma_Ma — Tue, 25 Apr 2023 09:38:59 GMT

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

Re: count occurrences in COLUMN AS STRINGS WITH DAX

Aadil_Sharma_Ma — Tue, 25 Apr 2023 09:47:24 GMT

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.

Re: count occurrences in COLUMN AS STRINGS WITH DAX

tamerj1 — Tue, 25 Apr 2023 10:09:40 GMT

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