Make a measure with a filter ignore user filters/slicers

[WorkHard]

I need to create a measure that counts the total quantity of an item while ignoring a specific keyword ("ignore").

The below DAX snippet works great except when I apply a filter in a visual or use slicers, I need the measure to ignore those filters. Is there a way to achieve this?

MyCount = CALCULATE (
    COUNT('My Data'[Model]),
    FILTER ( 'My Data', Search ( "ignore", 'My Data'[Display As],, 0 ) = 0 )
)

[pranit828 · Accepted solution]

HI @WorkHard 

You can use

MyCount = CALCULATE (
    COUNT('My Data'[Model]),
    FILTER (ALLEXCEPT('My Data','My Data'[col1],'My Data'[col2]), Search ( "ignore", 'My Data'[Display As],, 0 ) = 0 )
)

In place of col1 use the colunm used in the 1st filter and same for col2 for 2nd filter, if you have more add Col3 col4 ...