Cumulative count of created and completion dates

[Dan492813]

Hi All, 

I am trying to plot a cumulative count of created and complated dates on a graph.

I have the count working:

Count of Completed repairs 2 =

CALCULATE (

SUM('Orders view'[Count]),

FILTER (

ALLSELECTED ( 'Orders View' ),

'Orders View'[CompletedDate] <= MAX ( 'Orders View'[CompletedDate] )

))

It looks like this:

I have done the same for the created dates. 

I have plotted them on a graph using a date table as the axis but it is no longer cumulative:

Can anyone help please?

Thanks, Dan

[amitchandak · Accepted solution]

@Dan492813 , with date table , you need have formula

Count of Completed repairs 2 =
CALCULATE (
SUM('Orders view'[Count]),
FILTER (
ALLSELECTED ( 'Orders View' ),
'Date'[Date] <= MAX ( 'Date'[Date] )
))

for other date use userealtionship in first calculate and then use this

example

Count of Created repairs 2 =
CALCULATE (CALCULATE (
SUM('Orders view'[Count]), userelationship(Date[Date], 'Orders view'[date Created]))
FILTER (
ALLSELECTED ( 'Orders View' ),
'Date'[Date] <= MAX ( 'Date'[Date] )
))

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[Dan492813]

Any help with this would be great 

[Dan492813]

I'm getting the error:

"A single value for column 'Date' in table 'Dates' cannot be determind. 

Is this because the dates are in a different table?