Matrix table and filter criteria: trouble shoot

[quintans1]

Hello,

I have built a Matrix table where I have two dimensions: Entity and Location. I have a measure called "sumTotal."

I have placed sumTotal in "Filters on this visual" and have it set to greater than 34.

The problem is, the filter is looking at each row, whereas I want the filter to apply to Entity.

Because if I kept my filter in place, XYZ would show 59, instead of 100 since Grand Rapids and Benton Harbor are less than 34.

All three entities and their locations would qualify based on my criteria.

Any ideas?

[quintans1]

@lbendlin Thank you very much.

[lbendlin · Accepted solution]

Add REMOVEFILTERS(Location) to your measure.