Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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]))))
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]))))