Dynamic filtering according matrix values

[DomantasK]

Hello,

I'm wondering what could be a possible way to filter the data that is visualised in the matrix?

In this case, I have aggregated values displayed in matrix and slicer allows to filter only the detailed values (which appears in "Show data point as a table", second picture picture):
Current matrix and slicer:

"Show data point as a table" result. The sum of these detailed values is 1,27

So all in all, I need the slicer to be able to filter the values that are displayed in the matrix (range from 1,00 to 1,27 in this case), without losing the other (blurred) columns

[Anonymous · Accepted solution]

Hi @DomantasK 

I think you can create a sum column of the value, then put it to the slicer.

e.g 

Column = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Type]=EARLIER('Table'[Type])))

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.