Count Excluding Text

[DieLem]

Good Day,

I would like to count the total number of values in a column, EXCLUDING certain criteria. I want to exclude "This Value" and "This Value Two"  (Where "This Value" and "This Value Two" are text fields) and only count the remainder. How do I do it?

Thanks!

[Zubair_Muhammad · Accepted solution]

Hi @DieLem

Try this MEASURE

Measure =
CALCULATE (
    COUNT ( Table1[Column] ),
    NOT Table1[Column] IN { "This Value", "This Value 2" }
)

[DieLem]

@Zubair_Muhammad This is sweet.

Thanks so much!