Forum Discussion

DieLem's avatar
DieLem
Helper II
8 years ago
Solved

Count Excluding Text

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!

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi DieLem

     

    Try this MEASURE

     

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

2 Replies