Need Dropdown to Allow Exclusion

[Anonymous]

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!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490