Cumulative line chart based on text

[Anonymous]

I am just going to post this again... 

How do I make this into a cumulative line chart? These "Intern status" should just be added together even though they are different categories. 

Best regards,

Lisa 

[HoangHugo]

Hi

measure

cumulative_count =

 var date_select = SELECTEDVALUE([Date])

 var count_status = count([Intern Status])

 return CALCULATE(count_status, [date]<=date_select)

then, create a line chart, put [date] in X axis and measure in Y axis

[Anonymous]

Hi @HoangHugo 

Thanks, but I think something is missing because I did the measure but it does not add them up as you can see. I would like it to be cumuative_count = 2 under 25/07, 3 under 06/09 etc. 

[HoangHugo]

Yes, becasue you put "Intern Status" into matrix, so it will be a filter. To see right result, remove this column

[Anonymous]

@HoangHugo 

It still does not work. 

[mangaus1111 · Accepted solution]

Hi @Anonymous ,

I don´t know if I undestood well, but you can try with this measure

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.