Count the number of occurences contained in another columns strings

[CarsteFoRd]

Hi all 

I am trying to make a new column that count the number of occurences contained in another columns strings

My data looks like this (the desired result is marked in yellow)

Thanks in advance 
The Best Carsten 

[CarsteFoRd]

Thanks 🙂 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

expected result CC =
VAR _maxnumber =
    MAXX (
        ADDCOLUMNS (
            Data,
            "@countdelimiter", LEN ( Data[Path] ) - LEN ( SUBSTITUTE ( Data[Path], "|", "" ) )
        ),
        [@countdelimiter]
    ) + 1
VAR _generateseriestable =
    SELECTCOLUMNS ( GENERATESERIES ( 1, _maxnumber, 1 ), "@number", [Value] )
VAR _t =
    GENERATE (
        _generateseriestable,
        ADDCOLUMNS ( Data, "@item", PATHITEM ( Data[Path], [@number] ) )
    )
RETURN
    COUNTROWS ( FILTER ( _t, [@item] = EARLIER ( Data[ItemID] ) ) )