Slicer on Subtotals row of Matrix Visualization

[Anonymous]

Hi All,

I am working to include slicers on subtotals rows of Matrix Visluization:

P.S: I have build matrix as a pivot in excel so it has subrows too which contribute to the count of subtotals.

Below is the screenshot. I want to put slicer on yellow highlighted numbers:

Note: I tried to add the slicer on summation column however it filters based on sub rows values also (and I want only on subtotals

[Anonymous · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you unrelated table fields as source of slicer, then write a measure to check current row contents level and compare with selected value.

Measure Totals, The Final Word

Understanding DAX Auto-Exist

Clever Hierarchy Handling in DAX

Regards,

Xiaoxin Sheng