How to combine measures with table grouped in bins?

Anonymous — Mon, 04 Oct 2021 12:20:04 GMT

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))

Re: How to combine measures with table grouped in bins?

lbendlin — Sat, 25 Dec 2021 19:05:10 GMT

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.

topic Re: How to combine measures with table grouped in bins? in DAX Commands and Tips

How to combine measures with table grouped in bins?

Re: How to combine measures with table grouped in bins?