Running Total

[Anonymous]

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

[v-shex-msft]

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

[Fowmy]

@Anonymous 

You will need to have measure something like:

Running Total Closed = 
CALCULATE (
        [OpenTicketsMeasure],
        FILTER (
            ALL(dates),
            dates[date] < = max(dates[date])
        )
)
    

[Anonymous]

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]

Try:

Running Total Closed1 =
CALCULATE (
[Non-Dev Tags],
FILTER (
ALL('DAX Date Table'),
'DAX Date Table'[Date] <= max('DAX Date Table'[Date])
)
)

[Anonymous]

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 😞