Running total problem - not summing with zero

[Anonymous]

My running total script is not summing correctly values with 0.

**bleep** PoD 30 =

VAR vMax = MAX(Arkusz1[PoD30])

RETURN

       CALCULATE(

                     SUM(Arkusz1[Default30]),

                     FILTER(ALL(Arkusz1[PoD30]),

                     Arkusz1[PoD30] <= vMax)

)

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? 

 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.  

Instead I tried to use measure: Defaulted - where I can see 0 but still I can't get the right values:

PoD 30 =

VAR vMax = MAX(Arkusz1[PoD30])

RETURN

       CALCULATE(

                     SUMX(Arkusz1, Arkusz1[Defaulted]),

                     FILTER(ALL(Arkusz1[PoD30]),

                     Arkusz1[PoD30] <= vMax)

)

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try like

**bleep** PoD 30 =
VAR vMax = MAX(Arkusz1[PoD30])
RETURN

CALCULATE(
SUM(Arkusz1[Default30]),
FILTER(ALL(Arkusz1),
Arkusz1[PoD30] <= vMax && Arkusz1[Date] = max(Arkusz1[Date])
))

or

**bleep** PoD 30 =
VAR vMax = MAX(Arkusz1[PoD30])
RETURN
CALCULATE(
SUM(Arkusz1[Default30]),
FILTER(ALL(Arkusz1),
Arkusz1[PoD30] <= vMax && Arkusz1[year] = max(Arkusz1[year]) && Arkusz1[month] = max(Arkusz1[month])
))

[Anonymous]

I cannot add Arkusz1[date] to the Filter part as it's not a measure but just a column.

There you have sample data in table:

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