filter in a column filter all category except one

[MaliniBaktha]

 Hi, 

I have a column with different category, but I want to do the counts of all the category except one how do I do that ? 

I want to do the count of all category in channel_fourth except No Encounters . IS there a dax to omit one category ? like count(tab[Channel_fourth],filter(tab[channel_fourth]<> 'No Encounters') 

[christinepayton · Accepted solution]

Yes, typically something like calculate(count(tab[Channel_fourth]),tab[channel_fourth]<> "No Encounters"). The calculate function accepts filters after the expression, and <> is your "not equals". Make sure to use double quotes on the text value, not single quotes. 

[MaliniBaktha]

Thanks Christin, calculate worked 

[parry2k]

@MaliniBaktha try a measure like this:

countrows(filter(tab, tab[channel_fourth]<> 'No Encounters') )