Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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]))))
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |