Running total not working for one column?

[Anonymous]

Hello,

I'm trying to compare the running total of two counts, basically when an agreement became effective and then terminated. When I do this, the effective dates work exactly as expected. I run quick measure -> running total -> base value = count of agreement -> Field = effective date (year). However, when I try the same with terminated dates, the graph is completely wonky. 

The only thing I can figure that is different between the two is that the "terminated agreements" column has a bunch of empty cells (agreements have not been terminated yet). Any ideas?

Thanks, I'd really appreciate any help!

[Anonymous]

@Anonymous,

Please share sample data of your table so that we can test. 

In addition, you can create your own measure/column to calculate running total instead of using quick measures. This is a similar thread for you reference.

https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115

Regards,
Lydia

[Anonymous · Accepted solution]

Solved, using the method from this link.

https://community.powerbi.com/t5/Desktop/Area-chart-two-running-totals-each-with-a-different-date-co...

[Anonymous]

I should add: the "effective agreements" line graph looks as expected, slowly going up as agreements are added. The "terminated agreement" graph is flat, but occasionally bumps up; however, it doesn't seem to bare any relation to actual dates in the original data.