topic Acummulated tickets along time - Show acummulated after today - Cumulative Totals in DAX Commands and Tips

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

Anonymous — Mon, 19 Feb 2024 18:36:46 GMT

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] )
    )
)

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

Anonymous — Mon, 19 Feb 2024 18:54:16 GMT

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

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

Anonymous — Tue, 20 Feb 2024 01:40:18 GMT

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.