Line chart with running total

[SBR1D]

Hello

I have a line chart dates from a Date table on the x-axis. I then have Culmative active engage on the Y Axis. I have a date filter on the visual which is set to Relative date is this month. The thing is the line is showing the same value for all the days in September apart from the 1st. Why is it doing this, it should only show values for 1st and 2nd September right?

Count of active engage = CALCULATE(COUNTX('Table','Table'[measure1]))

Culmative active engage = TOTALMTD( [measure1], DATESMTD('Date'[Date]))

[SamWiseOwl]

Hi @SBR1D 

If a measure CAN show data it will.

So a simple measure like:
Basic Measure = 1

When in your visual will show for every single date available.

[SBR1D]

Thanks, so it cannot be done?

[SamWiseOwl · Accepted solution]

A quick a dirty way of dealing with this is create a measure that hides the calculation for days before today:
Hide values = If( selectedValue('Date'[Date]) <= Today(), [Culmative active engage], Blank())

It would be better to work which of the 3 measures is returning the value regardless of filters. What is the definition of Measure1?

[SBR1D]

that works!

Thank you

[SBR1D]

Oh ive labelled the measure wrong in the first post , here you go..

meausre1 = CALCULATE(COUNTX('Table','Table'[data_to_count]))

Culmative active engage = TOTALMTD( [measure1], DATESMTD('Date'[Date]))