Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Not applicable

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,




Not applicable

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.

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:



Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.