Calculate cumulative total of average

[Bessonnizza]

Hello there, 

I have a measure which calculate  cumulative total of opened tickets:

_opened / cumulative total / dynamic =
VAR check_date =
    SELECTEDVALUE ( 'calendar'[data] )
RETURN
    CALCULATE (
        SUMX (
            'tickets_created',
            IF (
                'tickets_created'[create_date] <= check_date
                    && 'tickets_created'[close_date] >= check_date,
                1
            )
        ),
        FILTER ( ALL ( 'calendar' ), 'calendar'[data] )
    )

How i can calculate avarege for this measure for last year?

[amitchandak]

@Bessonnizza , Try like

Example

Cumm Sales = CALCULATE(Average(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE(Average(Sales[Sales Amount]),filter(date,date[date] <=max(Sales[Sales Date])))

[Bessonnizza]

@amitchandak, thx for answer. 

If i need to calculate average of closed tickets, it was easy to calculate using yours example. But i need to calculate average of  open tickets. Count of open tickets in each day i get from this measure:

_opened / cumulative total / dynamic =
VAR check_date =
    SELECTEDVALUE ( 'calendar'[data] )
RETURN
    CALCULATE (
        SUMX (
            'tickets_created',
            IF (
                'tickets_created'[create_date] <= check_date
                    && 'tickets_created'[close_date] >= check_date,
                1
            )
        ),
        FILTER ( ALL ( 'calendar' ), 'calendar'[data] )
    )

[Anonymous]

Hi  @Bessonnizza ，

Try below dax expression:

average=Averagex(allselected('tickets_created'),[_opened])

If the above doesnt work,could you pls share me your sample data?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Bessonnizza · Accepted solution]

Hi @Anonymous 

Not working.

I managed to write measure myself:

_opened / average_wip =
DIVIDE (
    SUMX ( VALUES ( 'calendar'[data] ), [_opened / cumulative_total / dynamic] ),
    COUNTROWS ( 'calendar' ),
    0
)

[Anonymous]

Hi  @Bessonnizza ,

Glad to hear that ,so your issue is solved now,right?If so,could you pls mark the reply as answered to close it?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!