Running Total Zero

cons_austria03 — Wed, 01 Mar 2023 10:08:09 GMT

I have a very simple measure but the latest month is displaying zero since I have not added anything new for the latest month. In this scenario how can I get the value from last month instead of displaying zero?

Measure below:

Running Total =CALCULATE([Discovered Servers],FILTER(ALL(chargeableserverstrendreport), chargeableserverstrendreport[Discovery Date] <= MAX (chargeableserverstrendreport[Discovery Date])))

chargeableserverstrendreport has a relationship with my date table and display running total per month using the month field from the date table

My data below, I need the Running Total for Feb2023 to show 9 instead of zero

Month	Count	Running Total (what I'm getting)	Running Total (what I need)
Oct2022	1	1	1
Nov2022	3	4	4
Dec2022	3	7	7
Jan2023	2	9	9
Feb2023	0	0	9
Total	9	9	9

Re: Running Total Zero

andhiii079845 — Wed, 01 Mar 2023 12:34:41 GMT

[Discovered Servers] is a measure, right? I miss a sumx or something in the caluclate function.
You can try this:

Running Total =
Var _discover =  [Discovered Servers]
 Var _function = 
CALCULATE([Discovered Servers],FILTER(ALL(chargeableserverstrendreport), chargeableserverstrendreport[Discovery Date] <= MAX (chargeableserverstrendreport[Discovery Date])))
RETURN if(_discover=0,0,_function)

topic Running Total Zero in DAX Commands and Tips

Running Total Zero

Re: Running Total Zero