Forum Discussion

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 b...

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
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
  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
    Not applicable
    5 years ago
    No This is giving extremely wrong numbers.
    
    I tried using the measure:
    
    Running Total Closed =
    CALCULATE(
        [Non-Dev Tags]-[no of tickets by closed date],
        FILTER(
            ALLSELECTED('devops-query-spr2'[Created Date]),
            ISONORAFTER('devops-query-spr2'[Created Date], MAX('devops-query-spr2'[Created Date]), DESC)
        )
    )
    
    This is giving the difference of the two but i want to add the previous month's result to this result as well like Jan should be 98+46 = 144.
    
    I have tried couple of things but its not working 😞