DAX to display all the bins/ranges for each value in a column

[Anonymous]

Hi All,

I have a requirement to create bins/ranges for Total Sales as shown in the screenshot below:

I have tried creating DAX Measure for this :

Total Earned Sales Range =

SWITCH(

TRUE(),

[Total Sales] <= 0 ,"0 or blank" ,

[Total Sales] <=500000 , "0-500,000",

[Total Sales] <=1000000 , "500,000-1,000,000",

[Total Sales] <=1500000 , "1,000,000-1,500,000",

[Total Sales] <=2000000 , "1,500,000-2,000,000",

[Total Sales] <=2500000 , "2,000,000-2,500,000",

[Total Sales] <=3000000 , "2,500,000-3,000,000",

[Total Sales] <=3500000 , "3,000,000-3,500,000","3,500,000 and more")

But the result in PowerBI is as shown below:

This is the wrong output since there are many more bins for each vertical (to show that I have selected a few Client Ids).

Can you pls help me resolve this requirement as to how to display all the bins/ranges for each vertical?

Please let me know if you need more information or if the requirement is not clear enough.

Here is the sample data with expected output:
https://docs.google.com/spreadsheets/d/1aDJ3-bPulmtj4teKzgtuZ7CcsQ4HuhZs/edit?usp=sharing&ouid=11317... 
@Ashish_Mathur- Can you please help me with this?

[Ashish_Mathur]

Hi,

In the actual source data, do you have column C already or is that something you created manually?  Please share the exact column that are there in your raw data set.

[Anonymous]

Hi @Ashish_Mathur,
You are right, Column C is not there already in my dataset. Columns H and I are the ones I am trying to create. Updated the sheet.
https://docs.google.com/spreadsheets/d/1aDJ3-bPulmtj4teKzgtuZ7CcsQ4HuhZs/edit?usp=sharing&ouid=11317...

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur,
Thank you for the amount of time and effort you put into this.
That was very helpful.

[Ashish_Mathur]

You are welcome.