Running total problem - not summing with zero

Question

My running total script is not summing correctly values with 0.&nbsp;**bleep** PoD 30 = VAR vMax = MAX(Arkusz1[PoD30])RETURN&nbsp; &nbsp; &nbsp; &nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM(Arkusz1[Default30]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(ALL(Arkusz1[PoD30]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arkusz1[PoD30] &lt;= vMax))&nbsp;In my rows I have dates, and in columns I have PoD30. For every next value for PoD30 I would like to sum values from Default30 column which is representing 1 or 0 (default or not). For October 2020 I have 0 in 6-th month (column) where I should have still 6 value as this is correct running sum from 0 to 6 month. 7-th month is summing correctly. What should I correct to get right numbers?&nbsp;&nbsp;&nbsp;&nbsp;This is how looks like a table with particular columns/measures. I think problem is because I have blank values for October 2020 in 6-th month.&nbsp;&nbsp;&nbsp;&nbsp;Instead I tried to use measure: Defaulted - where I can see 0 but still I can't get the right values:&nbsp;PoD 30 = VAR vMax = MAX(Arkusz1[PoD30])RETURN&nbsp; &nbsp; &nbsp; &nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUMX(Arkusz1, Arkusz1[Defaulted]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(ALL(Arkusz1[PoD30]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arkusz1[PoD30] &lt;= vMax))

amitchandak · Answer

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
&nbsp;
Try like
&nbsp;
**bleep** PoD 30 =VAR vMax = MAX(Arkusz1[PoD30])RETURN
CALCULATE(SUM(Arkusz1[Default30]),FILTER(ALL(Arkusz1),Arkusz1[PoD30] &lt;= vMax &amp;&amp; Arkusz1[Date] = max(Arkusz1[Date])))
&nbsp;
&nbsp;
or
**bleep** PoD 30 =VAR vMax = MAX(Arkusz1[PoD30])RETURNCALCULATE(SUM(Arkusz1[Default30]),FILTER(ALL(Arkusz1),Arkusz1[PoD30] &lt;= vMax &amp;&amp; Arkusz1[year] = max(Arkusz1[year]) &amp;&amp; Arkusz1[month] = max(Arkusz1[month])))

anonymous · Answer

I cannot add&nbsp;Arkusz1[date]&nbsp;to the Filter part as it's not a measure but just a column.&nbsp;There you have sample data in table:&nbsp;YearMonthPoD30**bleep** PoD 30Default30Defaulted2020September00002020September20&nbsp;02020September32222020September40&nbsp;02020September53112020September65222020September70&nbsp;02020September80&nbsp;02020September90&nbsp;02020October00002020October21112020October32112020October44222020October56222020October60&nbsp;02020October78222020October89112020October911222020November00002020November20&nbsp;02020November33332020November45222020November50&nbsp;02020November68332020November711332020November80&nbsp;02020November90&nbsp;02020December00002020December22222020December35332020December46112020December58222020December69112020December70&nbsp;02020December80&nbsp;02020December90&nbsp;0

Forum Discussion

Running total problem - not summing with zero

2 Replies

Related content

Running sum

Running Sum Max Date

DAX Running Total Problem

SUM vs SUMX in running total problem

Running sum invert

Year	Month	PoD30	bleep PoD 30	Default30	Defaulted
2020	September	0	0	0	0
2020	September	2	0		0
2020	September	3	2	2	2
2020	September	4	0		0
2020	September	5	3	1	1
2020	September	6	5	2	2
2020	September	7	0		0
2020	September	8	0		0
2020	September	9	0		0
2020	October	0	0	0	0
2020	October	2	1	1	1
2020	October	3	2	1	1
2020	October	4	4	2	2
2020	October	5	6	2	2
2020	October	6	0		0
2020	October	7	8	2	2
2020	October	8	9	1	1
2020	October	9	11	2	2
2020	November	0	0	0	0
2020	November	2	0		0
2020	November	3	3	3	3
2020	November	4	5	2	2
2020	November	5	0		0
2020	November	6	8	3	3
2020	November	7	11	3	3
2020	November	8	0		0
2020	November	9	0		0
2020	December	0	0	0	0
2020	December	2	2	2	2
2020	December	3	5	3	3
2020	December	4	6	1	1
2020	December	5	8	2	2
2020	December	6	9	1	1
2020	December	7	0		0
2020	December	8	0		0
2020	December	9	0		0