hide matrix rows

[leonanmaciel]

I would like the rows in a matrix not to appear when the value that has the same name is selected in the slicer, as shown in the image the marked fields do not want to appear.

[Anonymous · Accepted solution]

Hi @leonanmaciel 

Do you mean that the value you checked will not appear in the matrix? If you want this effect, you can refer to the following solution.

Sample slicer data

Sample data table

Create a measure

Measure = IF(ISFILTERED('Slicer'[Column1]),CALCULATE(SUM('Table'[Column2]),FILTER('Table',NOT('Table'[Column1] in VALUES('Slicer'[Column1])))),CALCULATE(SUM('Table'[Column2])))

Output

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.