Forum Discussion

locle90's avatar
locle90
Icon for Helper I rankHelper I
4 years ago
Solved

Total Accumulated without data

Dear All, I have fomule to calculate the count of item with leadtime days 0-14.But some days we don't have the order then  i need day 7,8,9 should show with data 79. Could you help to advice how i ...
  • PurpleGate's avatar
    PurpleGate
    4 years ago

    As Lead time is 0-14 days,  I made a raw table called OrderLeadTime just 15 rows with the numbers 0-14

    Then I linked as a 1-* to your calculated column "Order Lead Time" in table LeadTime

     

    xx cumul = 
    var c = max(OrderLeadTime[OLT_Raw])
    var t = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),REMOVEFILTERS(OrderLeadTime[OLT_Raw]))
    var td = CALCULATE(DISTINCTCOUNT(Leadtime[Item]),OrderLeadTime[OLT_Raw]<=c)
    return divide(td,t,1) 

       

PurpleGate's avatar
PurpleGate
Icon for Resolver III rankResolver III
4 years ago

I see. If your column is a measure, and you cannot use SUM then how about this:

 

Wish Result = CALCULATE([insert your count measure here],FILTER(ALL('Leadtime'[OLT]),'Leadtime'[OLT] <= MAX ('Leadtime'[OLT])))

 

  • locle90's avatar
    locle90
    Icon for Helper I rankHelper I
    4 years ago

    Dear PurpleGate,

    Thanks for your strongly support but my result still same with my expactation .

     

     

    • PurpleGate's avatar
      PurpleGate
      Icon for Resolver III rankResolver III
      4 years ago

      try removing "distinct count" from your measure. 

      If this is referring to a column, then you can use sum, and if it is referring to a measure, you can just write the measure name.