cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevinwillis Frequent Visitor
Frequent Visitor

dynamic filter value - not equal to

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

 

 

3 REPLIES 3
gckcmc Member
Member

Re: dynamic filter value - not equal to

kevinwillis Frequent Visitor
Frequent Visitor

Re: dynamic filter value - not equal to

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

Re: dynamic filter value - not equal to

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

 

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 423 members 4,120 guests
Please welcome our newest community members: