Dax Measure where calculate & sum are used, but want to filter table if a column contains a string

[doubleclick]

Hey all, I have a simple DAX formula in Excel Powerpivot (NOT pbi)

=calculate(sum(table[Sales])

I want to filter it so that if [X Column] contains the string "pablo", only then will the sum be calcaulted. 

I've tried a bunch of different methods 

For some reason 'containsstring' is not a function available

[BeaBF · Accepted solution]

@doubleclick Try:

=
CALCULATE (
    sum(table[Sales]),
    FILTER (table, FIND ( "Pablo", Table[X Column],, 0 ) <> 0 )
)

Note that the function FIND is case-sensitive. Check this link for details:

https://www.sqlbi.com/articles/from-sql-to-dax-string-comparison/

B.