Acummulated tickets along time - Show acummulated after today - Cumulative Totals

[Anonymous]

Hi guys,

I need your help... I'm trying to show the accumulated open tickets along the months, but on visuals they extend until december.
I would like to see until the current month, I have try almost everything, but not worked, even the ChatGPT could give me a good answer. You are my last hope.
I use this measure:

CALCULATE (
    CALCULATE (
        COUNTROWS ( f_Suporte ),
        FILTER (
            ALL ( f_Suporte[##Related Status_Cliente] ),
            f_Suporte[##Related Status_Cliente] = "Ativo"
        ),
        FILTER (
            ALL ( f_Suporte[##StatusTicket] ),
            f_Suporte[##StatusTicket] = "ABERTO"
        )
    ),
    FILTER (
        ALL ( Date_Table_TR[Date] ),
        Date_Table_TR[Date] <= MAX ( Date_Table_TR[Date] )
    )
)

[Anonymous]

Hi @Anonymous ,

Glad to hear that your issue has been resolved. If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous · Accepted solution]

I got right now... always this way... post here and the insight comes. Amazing.
Here is the right measure:

CALCULATE (
    CALCULATE (
        COUNTROWS ( f_Suporte ),
        FILTER (
            ALL ( f_Suporte[##Related Status_Cliente] ),
            f_Suporte[##Related Status_Cliente] = "Ativo"
        ),
        FILTER (
            ALL ( f_Suporte[##StatusTicket] ),
            f_Suporte[##StatusTicket] = "ABERTO"
        )
    ),
    FILTER (
        ALL ( Date_Table_TR[Date] ),
        Date_Table_TR[Date] <= MAX ( Date_Table_TR[Date] )&&
        Date_Table_TR[Date]< MAX(f_Suporte[end_date])
    )
)