Calculated Column: Count string within column

[Abawde1]

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

[amitchandak · Accepted solution]

@Abawde1 ,

a new column

=

var _emp = [Employee]

return

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

[Abawde1]

Thank you amitchandak, works perfect