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