Recurring Revenue Measurement

Lodan Try the following. I believe you used MaxDate twice whereas the second time it should have been MinDate. You also waaaaaay overused CALCULATE. 

MRR Revenue NC = 
VAR MaxDate = MAX( 'Date2'[Date] )
VAR MinDate = MIN( 'Date2'[Date] )
VAR __Table = FILTER( ALL( 'CMD Items' ), [Completed Date] <= MaxDate && [End of Term] > MinDate )
VAR Result = SUMX( __Table, [MRR$] )
RETURN Result

I think you need to add REMOVEFILTERS( 'Date2' )

MRR Revenue2 = 
VAR MaxDate = CALCULATE( MAX( 'Date2'[Date] ) )
VAR MinDate = CALCULATE( MIN( 'Date2'[Date] ) )
VAR Result = CALCULATE(
	SUM( 'CMD Items'[MRR$] ),
    'CMD Items'[Completed Date] <= MaxDate,
    'CMD Items'[End of Term]> MaxDate,
    REMOVEFILTERS( 'Date2' )
)
RETURN Result