Forum Discussion
Cumulative items
Hi,
I need to do a histogram with 3 values:
Axis X = Leadtime
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:
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
Hi mgastalho
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.
https://www.youtube.com/watch?v=FPckiBv657c
I think you have almost got it, might just be missing just few details.
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.
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.
