dynamic filter value - not equal to

[Anonymous]

I have a table with SCCM data containing AddRemoveProgram data.  I can easily slice it up to find which computers have what SoftwareName installed. 

It has been requested to slice/filter the data for finding computers that DO NOT have the selected SoftwareName installed.  So when sliced by SoftwareName, I get table view with computers without the selected title.  I might be approaching this wrong but I cant seem to get started.

device             |  SoftwareName

computer1  |   application1

computer1  |  application2

computer1  |   application3

computer2  |   application 2

computer2  |   application4

computer3  |   application 1

computer3  |   application2

computer3  |   application4

I can slice by SoftwareName, select "application2", and get table view with "computer1, computer2, computer3"  or select "application4" and get "computer2, computer3"

I've been asked to label a slicer Not Installed and when selecting "application4" I see only "computer1" in the table view as NOT having SoftwareName "application4"

Is this possible?

Thank you,

kevin

[gckcmc]

Try this

https://community.powerbi.com/t5/Desktop/Reverse-Selection-in-Visuals-reverse-slicer/td-p/342036/pag...

[Anonymous]

I have 45,000 computers and 34,000 software titles.  I looked at the link you suggested and I dont think that solution is pratical in my situation.  My table already has 6.3 million rows.

[gckcmc]

it's going to permute your columns, but you can make calculated columns that are the inverse of each title, and then filter on those?  I realize it's not ideal, but would solve it.

also perhaps building a set of software programs as a separate table, and then build measures against that, something like this:

https://community.powerbi.com/t5/Desktop/Slicer-reverse-selection-in-chart/td-p/96316