How to get the opposite count of a filtered visual

[Anonymous]

So I have a column chart that gives me a count of items based on multiple different fields in the axis. What I want to do is flip this data so that I can see the count of items where these data fields don't apply. If someone has a suggestion please let me know. Thanks in advance and let me know if there is any additional information that I need to provide. Essentially I want the opposite of my data. 

[Greg_Deckler]

@Anonymous So like this? Inverse Aggregator - Microsoft Power BI Community

[Anonymous]

So each name would pop up in multiple rows. I would need to create something that can filter out names that contain each one of these values. So in this example if I wanted to show the count of names that don't relate to value 1 then I would get 1 name.  In the case of this table it would only be name:2345. I should be able to show this data in a visual or table. 

name	data values
1234	value 1
1234	value 2
1234	value 3
2345	value 2
2345	value 3
2345	value 4

[Greg_Deckler]

@Anonymous So more like: Inverse Selector - Microsoft Power BI Community

Let's see:

Measure = 
  VAR __SelectedNames = DISTINCT('Table'[name])
  VAR __AllNames = DISTINCT(ALL('Table'[name]))
RETURN
  COUNTROWS(EXCEPT(__AllNames,__SelectedNames))

[Anonymous]

@Greg_Deckler Do I still need a second table for this measure? I'm trying to make the comparison between this measure and the link you sent me. The link looks like exactly what I need. 

[Greg_Deckler]

@Anonymous Probably not, would have to actually test it. But the ALL should get rid of the slicer filter context and so you *should* be able to get away with a single table.

[Anonymous]

I tried it and didn't get the correct result. I think what I really need to do is create a new column. 

[Greg_Deckler]

@Anonymous Would ned to see sample data.