cancel
Showing results for
Did you mean:
New Member

## Cumulative items

Hi,

I need to do a histogram with 3 values:

Axis Y = Number of itens with the leadtime showed

Axis Y(2) = Percentage of itens on leadtime

I count how many items are in leadtime 1, 2, 3, 4.....

But now i need to trace a line with percent to know how many items i delivery with 80% sure in leadtime.

To do this count i have to do something like this:

 Days Items Cumulative % 1 2 2 25% 2 3 5 63% 3 2 7 88% 4 1 8 100%

Cumulative/ SUM(Items) = %

I don´t know how to do this cumulative.

I´ve done this:

Where Axis X is Leadtime and Axis y is total of items

I need to do this:

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

Hi @mgastalho ,

Based on your sample data, we can create two measures to meet your requirement.

``````Cumulative =
CALCULATE(SUM('Table'[Items]),FILTER(ALLSELECTED('Table'),'Table'[Days]<=MAX('Table'[Days])))``````

``````% =
var _cum = CALCULATE(SUM('Table'[Items]),FILTER(ALLSELECTED('Table'),'Table'[Days]<=MAX('Table'[Days])))
var _Total = CALCULATE(SUM('Table'[Items]),ALLSELECTED('Table'))
return
DIVIDE(_cum,_Total)``````

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

3 REPLIES 3
Community Champion

What you are looking for is pareto chart, once pareto chart is done you will need to conditionally format the color of the days bar to a different color when it is more than equal to 80%.

Check this link, it explain to do the same.

I think you have almost got it, might just be missing just few details.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,
Pranit

Super User II

based on your sample data, you need to create two columns.

``````cumulative1 = SUMX(FILTER(Sheet1,Sheet1[Days]<=EARLIER(Sheet1[Days])),Sheet1[Items])

%1 = Sheet1[cumulative1]/sum(Sheet1[Items])``````

I am not sure if this also works for your real data. please let me know if you have any questions.

Proud to be a Super User!

Community Support

Hi @mgastalho ,

Based on your sample data, we can create two measures to meet your requirement.

``````Cumulative =
CALCULATE(SUM('Table'[Items]),FILTER(ALLSELECTED('Table'),'Table'[Days]<=MAX('Table'[Days])))``````

``````% =
var _cum = CALCULATE(SUM('Table'[Items]),FILTER(ALLSELECTED('Table'),'Table'[Days]<=MAX('Table'[Days])))
var _Total = CALCULATE(SUM('Table'[Items]),ALLSELECTED('Table'))
return
DIVIDE(_cum,_Total)``````

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors