Power bi count MAX a character appears in a row

[Tim01425]

I want to calculate the max  of a special character appears in a row. The 2 special characters are either "/"  or " \" .

I would like to produce similar as below results using DAX.  

I have this formula but it only considers one charracter '/', and i'd like to consider both in the max count.

MaxPathCount =

MAXX(

    TableName,

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

)

Thank you so much.

[ChrisMendoza]

@Tim01425 - This help?

Column = 
SWITCH (
    TRUE (),
    FIND ( "\", TableName[Path],, 0 ) > 0, LEN ( TableName[Path] ) - LEN ( SUBSTITUTE ( TableName[Path], "\", "" ) ),
    FIND ( "/", TableName[Path],, 0 ) > 0, LEN ( TableName[Path] ) - LEN ( SUBSTITUTE ( TableName[Path], "/", "" ) ),
    BLANK ()
)

 

[ChrisMendoza]

@Tim01425 - Also as a measure:

[Tim01425]

Thank you so much for your hepl.

Is there a way to have a maximum betweem all rows? in this case it should be 8?

[ChrisMendoza]

@Tim01425 - DAX Fridays #200: Calculate the MAX of a measure - YouTube