Forum Discussion
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...
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:
https://community.powerbi.com/t5/Desktop/Slicer-reverse-selection-in-chart/td-p/96316