Power BI Running Total return the same value

Question

How running total returns the same value in Power Bi

TicketClosed_Total = 
CALCULATE(
    [TotalTicket_Pending],     
    FILTER(
        ALL('Ticket'[CompletedDate]),
        'Ticket'[CompletedDate] <= MAX('Ticket'[CompletedDate])
    )
)

TicketClosed_DateTbl = 
CALCULATE(
    [TicketClosed_Total],
    USERELATIONSHIP('Date'[Date_1],'Ticket'[CompletedDate])
)

I am using this formula and cannot able to return the value I wanr

How can solve this? 

Answer 1

Follow the basic two measures

cum_total_ticket = 
CALCULATE(
    SUM(Ticket[total ticket]),
    FILTER(
        ALL(Ticket),
        Ticket[CompletedDate] <= MIN(Ticket[CompletedDate])
    )
)

cum_sold_ticket = 
CALCULATE(
    IF(
        SUM(Ticket[sold ticket]) = BLANK(),
        0,
        SUM(Ticket[sold ticket])
    ),
    FILTER(
        ALL(Ticket),
        Ticket[CompletedDate] <= MIN(Ticket[CompletedDate])
    ) 

) 

Check the power bi training provided by intellipaat 

Also, check the youtube video