topic Re: Calculated Column: Count string within column in DAX Commands and Tips

Calculated Column: Count string within column

Abawde1 — Tue, 08 Feb 2022 12:44:34 GMT

I want to be able to count within a table, the number of times a value appears within a column.

For example i have the data below with 5 employees. And a [Hierarchy Path] string column.
I want to be able to count the number of times the [Employee] appears within the Column, [Hierarchy path].

Employee	Hierarhy Path	Column String Count
AA	EE \| AA	4
BB	EE \| AA \| BB	1
CC	EE \| AA \| CC	1
DD	EE \| AA \| DD	1
EE	EE	5

Re: Calculated Column: Count string within column

amitchandak — Tue, 08 Feb 2022 14:06:51 GMT

Abawde1 ,

a new column

var _emp = [Employee]

return

countx(filter(Table, search(_emp, [Hierarhy Path],,0) >0) , [Employee])

Re: Calculated Column: Count string within column

Abawde1 — Wed, 09 Feb 2022 08:45:49 GMT

Thank you amitchandak, works perfect