Forum Discussion

SBR1D's avatar
SBR1D
Helper III
2 years ago
Solved

Line chart with running total

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....
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    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?

SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

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's avatar
SBR1D
Helper III
2 years ago

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]))