cancel
Showing results for
Did you mean:
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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!

Highlighted
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!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors