Revenue by Customer & Year, Filtered Dynamically by additional field

Thank you both for telling me about Banding.  It might be the solution but I'm having trouble making it work.  What I want to do is always keep the filters on customer and transaction year.   In other words, I want to always sum by those fields, and then let my end user change those sums with additional filtering on Product Format, changing the bands a particular customer falls into dynamically.  Here is the table I have created based on some of your suggestions:

However, when I filter further by Product Format B, like my end user would, I get the following:

What I want is this:

In this way, the end user can see how the number of customers in each bucket would change if they eliminated certain product formats from the analysis.  

It seems like RevenueSum is my problem.  That equation doesn't change dynamically and therefore doesn't force the bands to change.  It calculates a static sum by customer and year.  Here is the formula. 

RevenueSum = CALCULATE(SUM('Purchasers'[Price]),ALLEXCEPT('Purchasers','Purchasers'[Customer],'Purchasers'[Transaction Year]))

How do I get that Sum to then change with additional filters?  In Tableau, this would be called a 'Context filter' which would be applied before the static sum is calculated.  I just can't figure out the equivalent in Power BI.

Thanks for all your help so far.  I really appreciate it.