Reverse Table Filters?

I have a table that filters by multiple categories, so when I insert data it automatically filters. I’m wondering how I can reverse this in a measure that averages/sums all the data WITHOUT xyz ...