Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Running Total show blank on dates

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
5 REPLIES 5
Anonymous
Not applicable

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
Helper II
Helper II

HI,@Anonymous 
Use

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

Running Total.png
Anonymous
Not applicable

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
Not applicable

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

 

thanks

dax
Community Support
Community Support

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors