Getting cumulative total of a grouped value

[Anonymous]

Hi Everyone,

I have following matrix table with grouped total days open and Year/Month

I'm trying to get cumulative total and tried following;

Cumulative Total = CALCULATE([Count of Issues],FILTER(ALLSELECTED(Query25),Query25[Month_Year]<=MAX(Query25[Month_Year])&&Query25[Total Days Open Excluding Q (groups)]<=MAX(Query25[Total Days Open Excluding Q (groups)])))

However, the result is as follows;

 As it can be seen above, only December column has the correct cummelative total. Cummelative total is working both horizontally and vertically. I just want to get cummelative total for each month.

Appreciate any help.

Thanks in advance.

Best Regards,

Ashan.

[Anonymous]

Hi @Payeras_BI,

Thank you so much. It works.

Best Regards,

Ashan.

[Payeras_BI · Accepted solution]

Hi @Anonymous ,

Try like this:

Cumulative Total =
CALCULATE (
    [Count of Issues],
    FILTER (
        ALLSELECTED ( Query25[Total Days Open Excluding Q (groups)] ),
        Query25[Total Days Open Excluding Q (groups)]
            <= MAX ( Query25[Total Days Open Excluding Q (groups)] )
    )
)

 Regards,