FAQ: How to filter a aggregate without filtering the table?

Here’s another FAQ we receive:
I want to have the summary values in my table (or aggregates in groupings) be filtered, but not filter the table itself, what can I do?

To do this, you will want to make use of the
SumIf, MaxIf, etc functions.

This will allow you to in effect apply a Sum function to a filtered subset of a column.

For example:
SumIf( [Sales], [Quantity] > 1 )

Avg, CountDistinct, Count, Max, Min, and Sum all have corresponding …If functions: Aggregate Functions

Added Formulas

Added FiltersControls