'DAX SUMMARIZECOLUMNS FILTER NOT IN or DOES NOT CONTAIN

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

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

powerbi dax

Solution 1:^[1]

Have you tried using CONTAINSSTRING?

EVALUATE
SUMMARIZECOLUMNS (
    Salesforce[SalesPersonName],
    FILTER (
        'Salesforc`enter code here`e',
        NOT ( CONTAINSSTRING ( Salesforce[SalesPersonName], "OPEN" ) )
    )
)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Angelo Canepa

'DAX SUMMARIZECOLUMNS FILTER NOT IN or DOES NOT CONTAIN

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]