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" a...
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" }
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi DieLem

 

Try this MEASURE

 

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