topic Re: How to get the opposite count of a filtered visual in DAX Commands and Tips

How to get the opposite count of a filtered visual

Anonymous — Thu, 29 Jul 2021 17:47:39 GMT

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.

Re: How to get the opposite count of a filtered visual

Greg_Deckler — Thu, 29 Jul 2021 19:13:00 GMT

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

Re: How to get the opposite count of a filtered visual

Anonymous — Thu, 29 Jul 2021 19:28:04 GMT

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

Re: How to get the opposite count of a filtered visual

Greg_Deckler — Thu, 29 Jul 2021 19:49:48 GMT

Anonymous Would ned to see sample data.

Re: How to get the opposite count of a filtered visual

Anonymous — Thu, 29 Jul 2021 19:53:10 GMT

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

Re: How to get the opposite count of a filtered visual

Greg_Deckler — Thu, 29 Jul 2021 20:01:51 GMT

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))

Re: How to get the opposite count of a filtered visual

Anonymous — Thu, 29 Jul 2021 20:55:48 GMT

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.

Re: How to get the opposite count of a filtered visual

Greg_Deckler — Fri, 30 Jul 2021 14:44:04 GMT

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.