Sum if contains text "404"

[Visar]

Hello guys,

I have a huge table with URLS and i want to make a custom measure to have the sum of sessions only for the Landing Pages containing "404"

I tried this but doesnt seems to work : 

somme 404 = 
if(
    CONTAINS('My Table';'My Table'[Page path level 1];"404");
        SUM('My Table'[Sessions])
)

Could you help me on this please ? 

thanks

Visar

[Zubair_Muhammad · Accepted solution]

@Visar

Try with following

somme 404 =
CALCULATE (
    SUM ( 'My Table'[Sessions] ),
    FILTER ( 'My Table', SEARCH ( "404", 'My Table'[Page path level 1], 1, 0 ) > 0 )
)