Forum Discussion

shaebert's avatar
shaebert
Helper III
4 years ago
Solved

Line Chart Comparing Running Total

Hello, below is an example of data I have for a table for people who register for events from two different years. I am looking to create a line graph that compares cumulative/running total over time...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    shaebert , You can get cumulative measure with help from date table 

     

    example

    Cumm = CALCULATE(SUM(Table[Value]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

     

    or

     

    Cumm = CALCULATE(SUM(Table[Value]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi shaebert ,

Please try below steps

1.my test table

2.add a line chart visual and create a measure

Measure =
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Date] <= cur_date )
RETURN
    COUNTROWS ( tmp )

If I have misunderstood your request, please feel free to let me know.

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.