PATHCONTAINS() - not working when I generated PATH() myself

Hi,

I am trying to use the PATHCONTAINS function where I have generated the PATH myself.

PATH is a column in my data and have values for each row.

My PATH looks like: 
A69|E37|B86|A49|E78||||||||


And tried to use like this:

DoesB86ExistInPATH = PATHCONTAINS([PATH], "B86"), but getting an error:

A single value for column 'PATH' in table '1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Can anyone help me with that ?

In the end I am trying to search if the string "B86" exists in my [PATH] column and if yes I want a binary outcome in my measure: DoesB86ExistInPATH.

Thanks.