Forum Discussion

amirebrahim's avatar
amirebrahim
New Member
8 years ago

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