Forum Discussion

mgastalho's avatar
mgastalho
New Member
6 years ago
Solved

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 leadtim...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.