CAGR computation

Hi everyone,

I am trying to compute the CAGR growth for "organic revenue".  However, the CAGR computation is wrong as it is simply giving me the CAGR of "Total reveneu" and not "Organic revenue".  Would be great if someone can help me figure what's going wrong with the formulas.  Below is the link to the power bi file as well for ease.

https://www.dropbox.com/s/4taoyigtytv84bc/Organic%20revenue%20CAGR%20calcualtion.pbix?dl=0

Also, here are some of the formulas that are being used to compute organic revenue:

Organic revenue = 
    VAR Revenue = CALCULATE(SUM('Table'[Total Revenue]))
    VAR Acquired_revenue = [Cumulative acquired revenue]
RETURN
    (Revenue - Acquired_revenue)

Cumulative acquired revenue = 
    VAR CurrentDate = MAX('Calendar'[Year])
    VAR StartDate = MINX(ALLSELECTED('Calendar'), [Year])
    VAR DateSelection = FILTER(ALLSELECTED('Calendar'), 'Calendar'[Year] > StartDate && 'Calendar'[Year] <= CurrentDate)
RETURN
    SUMX(DateSelection, [Total acquired revenue])

CAGR: Organic Revenue = 
    VAR BeginningDate = CALCULATE(MIN('Calendar'[Year]), ALLSELECTED('Calendar'[Year]))
    VAR EndingDate = CALCULATE(MAX('Calendar'[Year]), ALLSELECTED('Calendar'[Year]))
    VAR BeginningValue = CALCULATE([Organic revenue], FILTER('Calendar', 'Calendar'[Year] = BeginningDate))
    VAR EndingValue = CALCULATE([Organic revenue], FILTER('Calendar', 'Calendar'[Year] = EndingDate))
    VAR Years = (EndingDate - BeginningDate)
RETURN
    IF(BeginningValue <= 0, BLANK(), (EndingValue / BeginningValue)^(1/Years) - 1)

Thanks a ton

Shashank

Ashish_Mathur