Hierarchical cumulative line chart values not accumulating

[reaaeis]

I am attempting to create a line chart with cumlative values that works across a hierarchy (year/qtr/week). It works when viewed directly at the week level--directly being drilled down via the two straight arrows. When viewed in any other way it displays non cumulative values. This is any hiearchical level or directly at  the year or qtr level. Here is the Dax.

cncp Count of Case Number in Week =

CALCULATE(

    COUNT('cpnp'[Case Number]),

    FILTER(

        ALLSELECTED('Calendar'[WeekSeqNoInYear]),

        ISONORAFTER('Calendar'[WeekSeqNoInYear], MAX('Calendar'[WeekSeqNoInYear]), DESC)

    )

)

[v-juanli-msft · Accepted solution]

Hi @reaaeis 

Create measure

clc measure = IF(NOT(ISBLANK(COUNT('Table'[case number]))),CALCULATE(COUNT('Table'[case number]),FILTER(ALL('calendar'),'calendar'[Date]<=MAX('calendar'[Date]))))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.