Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running total problem - not summing with zero

My running total script is not summing correctly values with 0.   **bleep** PoD 30 = VAR vMax = MAX(Arkusz1[PoD30]) RETURN        CALCULATE(                      SUM(Arkusz1[Default30]),    ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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:

 

YearMonthPoD30**bleep** PoD 30Default30Defaulted
2020September0000
2020September20 0
2020September3222
2020September40 0
2020September5311
2020September6522
2020September70 0
2020September80 0
2020September90 0
2020October0000
2020October2111
2020October3211
2020October4422
2020October5622
2020October60 0
2020October7822
2020October8911
2020October91122
2020November0000
2020November20 0
2020November3333
2020November4522
2020November50 0
2020November6833
2020November71133
2020November80 0
2020November90 0
2020December0000
2020December2222
2020December3533
2020December4611
2020December5822
2020December6911
2020December70 0
2020December80 0
2020December90 0