When I have multiple slicers, I may need that one or more specific slicers ignore some others, for that, I can use the “edit interactions” options. Let’s take an example, I have those 3 simple visualizations (1 table and 2 slicers):

So if I am selecting something in “open”, the others will interact:

If I want “support” to ignore “open”, I will select the “open” filter then click on “format” (this option will not appear if I don’t select first the filter) and “edit interactions”:

Now on the top of the table and “support”, I will see those new icons:

For “support” to ignore “open”, I will click on this icon:

Then I will do the same thing for the table. To cancel both or one of them, just click on this icon:

Take note that I have to do that for each slicer, for instance, if I want the table to ignore also the “support”, I have to repeat the same process by selecting the “support” then click on the icon:

Once done, just click again on “edit interactions” to make disappear the icons. Take note that this option only works for visuals in the canvas area and not at all for the ones in the “filters” panel in the “filters on this page” or in the “filters on all pages”. For instance, I will put another “open” in “filters on this page” then filter it:

To make the table and “support” to ignore it:

• For the table, I will have to duplicate my table1 and called it table2
• For “support”, I will create a new table called table3

I will create a measure for table2 with this formula:

CALCULATE(COUNTROWS('table2'),ALL('table1'[argument]))

The ALL function cancels any filters. For instance, if I have a pie chart or a column chart, to ignore “open”, I will have to include it by creating a formula. For each slicer to ignore, I have to add another one like that:

NOTE: as you can see, I use only 1 CALCULATE for multiple different tables

Then I will create a relationship:

I will create a new table with the table2 and a new “support” slicer with the table3:

NOTE:

• For the new table, since the relationship is on both directions, I have to use the measure
• For the new slicer, since the relationship is on single direction, there is no need for a measure

To make disappear the measure, I will just have to reduce its column size but first, I will have to turn off the “text wrap” option: