Cumulative Percentage Bins in DAX

[Anonymous]

Hi All,

I am stuck in a problem where I need to split the customers in the respective cumulative percent bins. Here is the sample input data:
Input:

Customer	Amount
A	10
B	20
C	30
D	40
E	50
Total	150

Output:

		Actual per	Cumulative per
Customer	Amount
A	10	6.67%	6.67%
B	20	13.33%	20.00%
C	30	20.00%	40.00%
D	40	26.67%	66.67%
E	50	33.33%	100.00%
Total	150

Basically I want to create visuals based on the cumulative percent bins the customer is falling in. E.g below based on the above output:

	Visual 1		Visual 2		Visual 3		Visual 4		Visual 5
Customers	A,B		C				D		E
Range	0-20%		21-40%		41-60%		61-80%		81-100%

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/l7mv295y4tqaahx/adityapowerbi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[wiz_lamp]

Hi @Jihwan_Kim , May you please share your solution again. As the PBI fIle is not available any more.

[wiz_lamp]

Hi @Jihwan_Kim I did it myself, by looking at the problem description. 🙂

[Syndicate_Admin]

Good morning Syndicate_Admin, this solution is the ideal one for a similar problem that I want to solve, you could support me by sharing the pbix of how you built it???

I remain very attentive, and grateful for your response.

[Anonymous]

@Jihwan_KimThis is what I was looking for. Thanks for your solution.

[Anonymous]

@amitchandakI am struggling to get cumulative percentage of percentages here. Binning and bucketing will be next challenges. Actual per is nothing % of total for which I have created any measure. Cumulative percent is the actual runing total of this percent of total values.

[amitchandak]

@Anonymous , You have to try binning and bucketing for that

refer my video: 

https://youtu.be/CuczXPj0N-k

or

https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization