Dax measure with wrong value.

[ROG]

Hi all,

I need to create a new YTD Var measure similar to the previous one.

The result should have approximate values, but as you can see the YTD Var column is very different. Would you know why the result is wrong from the new measure?

(old measure) XX_YTD_NET_CHURNR_Var = [XX_NET_CHURNR] - CALCULATE(TOTALYTD(DIVIDE(SUM(monthly_churn_db_full[NET_CHURN]),SUM(monthly_churn_db_full[OB])),monthly_churn_db_dates[DATE_KEY]))

(new measure) Net Churn YTD Var = [Net Churn - 30D%] -
CALCULATE(TOTALYTD(DIVIDE([Net Churn - 30D],[Opening Base - 30D]),'🔎Calendar'[Date]))

Below are each field I'm replacing, and as you can see on the new report I have measures and not a field. 

[XX_NET_CHURNR] --> [Net Churn - 30D%]
SUM(monthly_churn_db_full[NET_CHURN]) --> [Net Churn - 30D]
SUM(monthly_churn_db_full[OB] --> [Opening Base - 30D]
monthly_churn_db_dates[DATE_KEY] --> Calendar'[Date]

Output result from old measure.

Output result from new measure.

Thank you!

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523