Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running Total

Hi guys,

 

I have the below graph and I want to show the running total in it.

 

Please let me know the best approach for this.

 

i mean the open ticket for Dec should be 98, for Jan it should be (123-77) + 98 = 144, for Feb (128-145) + 144= 127 and so on. In the end for june i should get 83 as open.

 

is there any DAX calculation for this or should I consider creating a quick measure?

 

Regards,

Himanshu

 

 

 

 

Need Help

5 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    You will need to have measure something like:

    Running Total Closed = 
CALCULATE (
        [OpenTicketsMeasure],
        FILTER (
            ALL(dates),
            dates[date] < = max(dates[date])
        )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I created the below measure but its not giving correct value.

       

      Running Total Closed1 =
      CALCULATE (
      [Non-Dev Tags],
      FILTER (
      ALL('DAX Date Table'[Date]),
      'DAX Date Table'[Date] <= max('DAX Date Table'[Date])
      )
      )
       
      For Jan it should be 144 and 85 on last month i.e 85 but its coming wrong.
       
      It is capturing the created count only. 
       
      Note : I have one active relationship(created) and one inactive(closed).
       
      Please advice !!!
       
       

       

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        Try:

        Running Total Closed1 =
CALCULATE (
[Non-Dev Tags],
FILTER (
ALL('DAX Date Table'),
'DAX Date Table'[Date] <= max('DAX Date Table'[Date])
)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng