Forum Discussion
Helper IIfilter in a column filter all category except one
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')
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.
3 Replies
- christinepayton
Most Valuable Professional
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.
MaliniBakthaThanks Christin, calculate worked
- parry2k
Super User
MaliniBaktha try a measure like this:
countrows(filter(tab, tab[channel_fourth]<> 'No Encounters') )
