Running Total show blank on dates

[Anonymous]

Hello all

I hope you can give me help

I would like to show running totals, but only until the last call.  So my matrix shows below, so if nothing happened on 03/01/2019 then it stays blank

Date                                  Running Total

01/01/2019                             10

02/01/2019                             25

03/01/2019                           

04/01/2019                             47

05/01/2019                             63

My current measure

Calls Completed =

CALCULATE (

    DISTINCTCOUNT( Calls[ID] ),

    FILTER (

        ALL( 'calendar'[Date]),

       'calendar'[Date] <= MAX ( 'calendar'[Date] )

       )

       )

Thanks

Joe

[Anonymous]

Just Use this

IF(logical_test>,<value_if_true>, value_if_false)

and replace your blank with 0.

Your Graph will render with no error.

[nahid3152]

HI,@Anonymous 
Use

RunningTotal = CALCULATE([SUM],FILTER(ALL(Sheet1[Date]),Sheet1[Date] <= Max(Sheet1[Date])))
Format Date  from modeling 

[Anonymous]

Hello Nahid

I'm using the same formula already as you suggested. Which works if I want to populate the blank dates, but I  want to show when no sales appear. So the 03/01/2019 appears as blank

Thanks

Joe

[Anonymous]

I solved it by using the dates in the call's table instead of the date table

thanks

[dax]

Hi PoweredOut,

It seems that you solve this problem, right?If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.