DAX SUMMARIZECOLUMNS FILTER NOT IN or DOES NOT CONTAIN

[mcornfield]

Hello I am writing a DAX query and I am trying to filter out values that contain the word "OPEN" 

EVALUATE
SUMMARIZECOLUMNS ( 
Salesforce[SalesPersonName]
,
FILTER('Salesforce',Salesforce[SalesPersonName]<>"OPEN")
)

[AlexisOlson]

I'd recommend this:

EVALUATE
SUMMARIZECOLUMNS (
    Salesforce[SalesPersonName],
    FILTER (
        VALUES ( 'Salesforce'[SalesPersonName] ),
        NOT CONTAINSSTRING ( Salesforce[SalesPersonName], "OPEN" )
    )
)

[amitchandak · Accepted solution]

@mcornfield , Try like

EVALUATE
SUMMARIZECOLUMNS (
Salesforce[SalesPersonName]
,
FILTER('Salesforce',Search( "Open",Salesforce[SalesPersonName],,0) =0 )
)