Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello experts
I need to create a cumulative Graph like the picture that I will attack here.
I only need to count the data inside the open and closed column if the value of the cells equal to 1.
Additionally, I made the month column data type to numbers Is this okay for DAX code??
Here is my DAX code which is not working currently
open cumulative =
CALCULATE (
COUNTA ( IF('Data'[Open] = 1) ),
FILTER (
ALL ( 'Data'),
'Data'[month] <= MAX ( 'Data'[month] )
)
)
Cloased cumulative =
CALCULATE (
COUNTA ( IF('Data'[Closed] = 1)),
FILTER (
ALL ( 'Data'),
'Data'[month] <= MAX ( 'Data'[month] )
)
)
I appreciate your help
here is the Graph that I want my code to generate for me:
Have you looked at the "Running Total" Quick Measure?