Forum Discussion
locle90
Helper I
Helper ITotal 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 ...
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
Resolver III
Resolver IIIHi,
Try this measure
Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'[OLT]),'Table'[OLT]<=MAX('Table'[OLT])))
locle90Dear PurpleGate,
My DAX count mean : " count of item on data list". So i can use the Sum fomula like you.
Could you refe DAX bellow and give your adivice.
VN OLT = CALCULATE (DISTINCTCOUNT(Leadtime[Item]),FILTER (ALLSELECTED(Leadtime),Leadtime[OLT] <= MAX( Leadtime[OLT])))- PurpleGate
Hi Locle90,
When I use that formula, it works to count the rows with data. I have 11 rows in total and 8 of them have data in them in the "count" column.
I put below the result. It works well, if this is what you are after!
VN OLT = CALCULATE(DISTINCTCOUNT('Table'[Count]),FILTER(ALLSELECTED('Table'[OLT]),'Table'[OLT]<=MAX('Table'[OLT])))
- locle90
Dear PurpleGate,
I tried with your DAX but the result still same.Could you help to share the fomula of measure ?