How to create a dynamic table with revenue spend categories

[Anonymous]

Hi,

I have the below data and need to create a table based on the spend category per customer., but dynamic based on the selected weeks.

For all the customers with revenue below $2000, I will sum their revenue and put them in the category 0-2000, and the rest of the revenue will sum to the category >2000. This however needs to be dynamic, based on the weeks that I select. Also I need to be able to select multiple weeks and not single select. 

Any ideas how to create this measure?

Thanks!

Sample data

Quarter	Week	Customer	Revenue
1	1	A	$    123.00
1	1	B	$ 1,664.00
1	1	C	$    231.00
1	1	D	$ 5,464.00
1	1	E	$      32.00
1	1	F	$ 3,463.00
1	2	A	$    145.00
1	2	B	$      56.00
1	2	C	$ 1,430.00
1	2	D	$ 1,340.00
1	2	E	$ 6,506.00
1	2	F	$      35.00

Result 1

Week 1	Revenue
$0-$2000	$   2,050.00
>$2000	$   8,927.00
Result 2
Quarter 1	Revenue
$0-$2000	$   3,649.00
>$2000	$ 16,840.00

[amitchandak · Accepted solution]

@Anonymous , seem like you are looking for bucketing/binning

check if these link by me can help

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Anonymous]

Thank you @amitchandak !