Cumulative count for graph

Hi Anonymous,

Please use measure to instead the calculate column, current power bi not support dynamic calculated column based on slicer or filter.

Regards,

Xiaoxin Sheng

Anonymous i think the issue here is that you need to create a date table, have you done that and then link the date to the date table

I initally solved this issue, and now Ive made it far more complicated.

I essentially have a table with two dates in it: StartDate and ActualStart. Every row has a StartDate but the ActualStart can be blank so I adapted the formula to ignore blanks. 

My adaptatons work perfectly if I put them in indiviual graphs but I need to overlay them on on graph. Using either date as the X axis breaks the other count (Because I think it ignores dates and just counts values)

Attached are the Measures and some images of the current broken graph. 

As you see in the data the line Cumulative Tasks Actually Started shouldnt stay flat? But tasks planned to start is perfect. If i change the X axis to ActualStart then it reverses with Actually Started working but Start Date broken.

Cumulative Tasks Planned To Start = CALCULATE (COUNTROWS('Asta Outputs - Task'), FILTER (ALLSELECTED('Asta Outputs - Task'), 'Asta Outputs - Task'[StartDate] <= MAX('Asta Outputs - Task'[StartDate])))

Cumulative Tasks Actually Started = CALCULATE (COUNTROWS('Asta Outputs - Task'), FILTER (ALLSELECTED('Asta Outputs - Task'), 'Asta Outputs - Task'[ActualStart] <= MAX('Asta Outputs - Task'[ActualStart])), NOT(ISBLANK('Asta Outputs - Task'[ActualStart])))

Thanks,