Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need Dropdown to Allow Exclusion

Hi All,

 

I would like my slicer to exclude certain populations even if the seperate populations within the slicer are not mutually exclusive. I have tried several DAX queries and the NOT function does not work as expected.  This is what I was attempting to use:

 

TESTExcludedOrders = CALCULATE([Total Orders], NOT CustomerTags[Name] IN ALLSELECTED(ExcludeCustomerTags[Name]))
 
Feel free to critique or to give any ideas. Thank you so much!