Forum Discussion
Filtering out value from a table based on slicer selection
I have two tables on my report page.
The first table shows vendors and sales. A slicer controls which vendor is shown.
I have a 2nd table that should show all vendors, less the vendor selected in the slicer. I can edit interactions so that the slicer doesn't fitler the 2nd table, but I want the chosen vendor to not appear.
Hi Thackeb
You can refer to the following solution.
Sample data
Table
Table 2
1.You can create a slicer table to put the vendors
2.Create the following measures
Measure_refectedbyslicer = CALCULATE(SUM('Table'[Column2]),FILTER('Table',[vendors] in VALUES(Slicer[ vendors])))Measure_notrefectedbyslicer = IF(ISFILTERED(Slicer[ vendors]),CALCULATE(SUM('Table (2)'[Column2]),FILTER('Table (2)',NOT([ vendors] in VALUES(Slicer[ vendors])))),CALCULATE(SUM('Table (2)'[Column2])))3.Put the measures to the visual
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Thackeb You can use Edit interactions here for achieve your problem, where the second table shows all vendors except the one selected in the slicer.
Create a slicer that allow users to select a vendor this slicer will control the first table, after that duplicate the first table that shows vendors and sales to create a second table. Click right on table in the fields pane and selecting duplicate.
Here to prevent the slicer from affecting the second table, you need to adjust the intercations between the slicer and the second table, after this slicer is not affecting the second table, you can apply a filter to the second table to exclude the selected vendor. See your report, select a vendor in the slicer for the first table, and observe that the second table showa all vendors except the selected one.
Hi Thackeb
You can refer to the following solution.
Sample data
Table
Table 2
1.You can create a slicer table to put the vendors
2.Create the following measures
Measure_refectedbyslicer = CALCULATE(SUM('Table'[Column2]),FILTER('Table',[vendors] in VALUES(Slicer[ vendors])))Measure_notrefectedbyslicer = IF(ISFILTERED(Slicer[ vendors]),CALCULATE(SUM('Table (2)'[Column2]),FILTER('Table (2)',NOT([ vendors] in VALUES(Slicer[ vendors])))),CALCULATE(SUM('Table (2)'[Column2])))3.Put the measures to the visual
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.