Forum Discussion
amirebrahim
8 years agoNew 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:
1 Reply
- Greg_Deckler
Community Champion
Have you looked at the "Running Total" Quick Measure?