How to use Manual Numeric ranges? Groups/Bins

[Anonymous]

Hello all
I have Store Id's, month and sales$ for 2019. This is my raw data.

TABLE1

I want the result like below. 
I got the answer for Store count. I want
1.The sum of the sales of the all doors which fall under that range, and
2.the average sales of each door in that range.

Sales range	Store count whose sum(sales) is between this range	Sum of sales between that range	Average of each door in this range
0-30	1	27
30-100	1	80
100-200	4	…
200-400	1	….
>400	1

How do I do this. Please help.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

The folks from SQLBI have done a good article on this process.  You can find it here: https://www.daxpatterns.com/dynamic-segmentation/