calculation

Hi MichielvS,

Based on my understanding, for 201501 month, there is 2=1+1(AandB) Churn in Table2, 2=1+1(AandB) Subcription in table1, so 100%=2/2. And for 201502 month, there is 0=0+0(A and B) Churn in Table2, 2=1+1(A and B) Subcription in Table1, so 0%=0/2, right? If it is, please review the following steps.

First, click New table under Modeling in home page, create two new tables using the following formulas.

Table11 = SUMMARIZE(Table1,Table1[Month],"count",SUM(Table1[Subscription]))

Table22 = SUMMARIZE(Table2,Table2[Month],"count",SUM(Table2[Churn]))

Please see the new tables.

Then create relationship between Table11 and Table22.



In table22, create a calculated column using the formula, create a table visual to show the expected result.

Chrun% = Table22[count]/RELATED(Table11[count])

If this is not what you want, please let me know.

Best Regards,
Angelia