How to combine measures with table grouped in bins?

[Anonymous]

I have the below table:

(Columns Revenue 1, 2,3 are just different groups… the revenue shall appear in only one of them…  either 1,2 or 3… and then repeated in ‘Revenue’ column).

I want to create a stacked bar chart… (like below)

Where in the Y axis, I shall have custom bins (ie 0-100, 101-200 and 201-100000). And in the x axis a stacked with a count on distinct clients.

What I have so far is 3 measures (see below)  to achieve the distinct count on the clients, but I am unable to produce the bins and display it in the y axis as above, how can I achieve it??

CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue1]>0))

CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue2]>0))

CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue3]>0))

[lbendlin]

Hopefully your source data comes in a better format. Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.