Filtered aggregates are used to include only some rows into the aggregation

select customer_id, 
       sum(amount) as total_amount,
       sum(amount) filter (where amount > 10000) as large_orders_amount
from customers
group by customer_id;

This can be re-written as

select customer_id, 
       sum(amount) as total_amount,
       sum(case when amount > 10000 then amount end) as large_orders_amount
from customers
group by customer_id;

Back to the SQL Feature Comparison