Matrix visual not filtering the data for all months

Hi Anonymous ,

If you turn the matrix into a table, you will find that it can be successfully filtered. This is by design. The matrix applies the measure/value filter at the Row totals granularity, not at the cell granularity.

Take a simple example, for the below sample.

Put it in a matrix.

In the visual filter, if the setting value is greater than 5, then the Row B is filtered out, but Row A not, because for Row A, the value is 10(1+2+3+4).

If the setting value is greater than 10, both the two rows are filtered out.

Additionally, when a measure is applied to a visual filter, each row produces a result, not each cell.

Still take the above sample as an example, I create a measure.

Measure = MAX('Table'[Value])

When I put the measure in the visual filter, for each cell in Row A, the measure result is 4 (which is the maxmum in the row).

So when the measure filter is greater than 3, no row be filtered out.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.