Extra blank (total-like) first row in table visual when using running tunning total

[phhs80]

Hi everyone,

I’m facing an issue with a running-total measure that’s adding an extra first row (blank date) at the top of my table visual.

Below are the screenshots that illustrate the problem:

• Data sample – my fact table (mytable)
  
  

  

   

• Table visual – note the extra first row (red box)
  
  

  

   

My DAX measure is:

Running total =
VAR d = MAX('calendar'[Date])
RETURN
CALCULATE(
    SUM('mytable'[Income]),
    FILTER(
        ALL('calendar'[Date]),
        'calendar'[Date] <= d
    )
)

What I want:
Only the actual date rows (e.g., 01-12-2020, 01-01-2021, …).
What I’m getting:
An extra first row with a blank date showing the grand total (same as the bottom total).

Additional info:

• 'calendar' is marked as the Date table.

• There’s a 1:1 relationship (both sides) between 'calendar'[Date] and 'mytable'[Date].

• I prefer a pure DAX solution, not a visual/page filter (like “Dates[Date] is not blank”).

Has anyone found a robust way to avoid that initial blank/grand-total row when computing running totals?

Thanks in advance for any guidance!
—Paul

[Jihwan_Kim · Accepted solution]

Hi, 

Please try something like below, and please check the attached pbix file.

Put Calendar[Date] column to the visualization

Create one to many relationship with single direction.

And, try to write the measure like below, if you do not want to see no-data-date.

Running total =
VAR d =
    MAX ( 'calendar'[Date] )
RETURN
    IF (
        SUM ( 'mytable'[Income] ),
        CALCULATE (
            SUM ( 'mytable'[Income] ),
            FILTER ( ALL ( 'calendar'[Date] ), 'calendar'[Date] <= d )
        )
    )

[phhs80]

Thanks a lot, Jihwan_Kim! Keeping my whole setting but replacing my Rolling total measure by yours fixes the issue completely.