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:
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:
Go to Solution.
Hi @mgastalho ,
Based on your sample data, we can create two measures to meet your requirement.
var _cum = CALCULATE(SUM('Table'[Items]),FILTER(ALLSELECTED('Table'),'Table'[Days]<=MAX('Table'[Days])))
var _Total = CALCULATE(SUM('Table'[Items]),ALLSELECTED('Table'))
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
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.
View solution in original post
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!!👍
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!
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021