Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
amirebrahim
New Member

I need help to build a Cumulative graph.

 

 

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:
Cumulative.png

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

Have you looked at the "Running Total" Quick Measure?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors