Labeling summarized data into groups

[RobbLewz]

I have a requirement to get the count of clients that fall within a specific sales group. 

Tables

DimClient

ClientId, ClentName

FactSalesRecord
ClientId, DateKey, SaleGBP.. etc

DimDate

DateKey, DateYear, DateMonth etc...

The user, in the report would select the year and month(s) to filter the report down too.  Only one year can be selected.

One of the visuals we need is someting like this:

Band	Client Count (Distinct)	Sales Total
100k +	20	£1,450,100
50k-99.99k	30	£3,001,256
10k-49.99k	100	£870,875

So the sales total would be the sum of the clients sum total for the selection.

I can make a table with, min and mix values, the band as a column, but can't figure out how to sum the clients up and filter where the sum is between the min and max totals in a way to display it as above.

[amitchandak · Accepted solution]

@RobbLewz , Not very clear. Do you need Dynamic Bucketing on a measure?

If yes, you need an independent bucket table and use that in measure.

refer that in my video :https://youtu.be/CuczXPj0N-k

If not. please explain with an example and   Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.