inverted
1 Topic
Inverted Slicer Results
I thought this would be rather straightforward but it's not been at all. I have a slicer filtering on Category in a table which functions just fine. Let's call this table1. I'm trying to understand how I can create a dynamic table (table2) which contains all the items filtered from table1 using the slicer. Been researching this all day and I found the following: table2 = FILTER( ALL('table1'), NOT('table1'[Category] IN VALUES('table1'[Category])) ) When I apply the slicer this doesn't return anything in table 2. Table2 is empty. How can I return the inverted results of the slicer to populate table2 with those results unless there is another way. Thanks in advance.Solved764Views0likes3Comments