Cumulative calculation issue

-- Of course, 'Calendar' must be linked to
-- Registered Date and Cancelled Date, one
-- relationship being active (probably the
-- one to with Registered Date).

[Registered To Date] =
var __lastVisibleDate = MAX ( Dates[Date] )
var __registeredToDate =
	CALCULATE(
		DISTINCTCOUNT( ShowMembers[UniqueID] ),
		'Calendar'[Date] <= __lastVisibleDate,
		USERELATIONSHIP(
			'Calendar'[Date],
			ShowMembers[Registered Date]
		)
	)
return
	__registeredToDate
	

 [Cancelled To Date] =
var __lastVisibleDate = MAX ( Dates[Date] )
var __cancelledToDate =
    CALCULATE(
        DISTINCTCOUNT( ShowMembers[UniqueID] ),
        'Calendar'[Date] <= __lastVisibleDate,
        'Calendar'[Date] <> BLANK(),
        USERELATIONSHIP(
            'Calendar'[Date],
            ShowMembers[Cancelled Date]
        )
    )
return
    __cancelledToDate

Calendar must be marked as a Date table in the model.

Best

Darek