Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
Solved

Running Total Line Chart with Filters

Hello 

 

Not even sure its possible but can anyone help me do a measure that can be used in a Line Graph that shows Month at the bottom and Totals on the side.

 

I want the monthly total for overtime.

I think the problem is I have page filters so it keeps changing it.

 

I tried something like - 

 

Month by Month = CALCULATE(SUM('DB Overtime Master'[Total],FILTER('Month','Month'[Month])))

 

Thanks
Ross

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Do you mean like this?

      

     

    Your measure is the Value and your month is the Axis.

     

    Alter your measure to this:

    CALCULATE(SUM('DB Overtime Master'[Total],ALL('Month'[Month]))

4 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    I'm not clear what do you want to achieve
    do you mean YTD calculation? can you share sample data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Do you mean like this?

      

     

    Your measure is the Value and your month is the Axis.

     

    Alter your measure to this:

    CALCULATE(SUM('DB Overtime Master'[Total],ALL('Month'[Month]))

    • rosscortb's avatar
      rosscortb
      Post Patron
      7 years ago

      Thank you. Sometimes its quite frustrasting as it can be a , or ( in the wrong place and throws whole thing out.