power bi count MAX the number of times a character appears in a row

[Tim01425]

I want to calculate the max a special character appears in a row. As per teh example below, row 5 has the maximun "\" in the column. I would like to produce similar resaults using DAX. 

I tired the following but it's not working: Max character= CALCULATE(max('table'[Path]),SEARCH("\";'table'[Path];;0)) 

I am unable to write required dax to fulfill these conditions. Can someone please help ? Thank you for your valuable help.

[Tim01425]

Thank you FreemanZ... this is exactly what I needed.

 very much appreciated

[FreemanZ · Accepted solution]

try to create a measure with the code below:

MaxPathCount =

MAXX(

    TableName,

    LEN(TableName[Path])  - LEN( SUBSTITUTE(TableName[Path], "\","") )

)

i tried with simplified data and it worked as below