Revenue by Customer & Year, Filtered Dynamically by additional field

Hi Cotter2000

Try the following

1. Create a Band Table with the following columns

    RevenueBucket , MinValue, MaxValue

2. Example

This in only an example , the Revenue Group , Min and MAx Values will depend on the buckets you need.

3. Next  crete a measure of RevenueSum , which I presume you already have.

4. Create a measure called ReturnBandGroup

    ReturnBandGroup =
 CALCULATE(
    VALUES (RevenueBand[RevenueGroup]),
    FILTER (
        RevenueBand,
        [RevenueSum] >= RevenueBand[Min]
     && [RevenueSum] <= RevenueBand[Max]
    )
)

5. Now use this ReturnBandGroup measure in your reports.

If this solves your issue please accept it as a solution and also give KUDOS.

Cheers

CheenuSing