Is it possible to have a calculated column based on other columns in a matrix?

[alexBL]

For exmaple this is my data:

I am looking to add another colum shows the change in counts between 2019 and 2020, and also the % change. So for example france would have a value of -113 for the chage in counts and 20% change %.

[v-jingzhang · Accepted solution]

There @alexBL

Is this what you want?

I realized this with measurements. You can download the PBIX from here. Please let me know if this helps.

2019 = SUMX(FILTER(Table1,Table1[Year]=2019),Table1[Value])

2020 = SUMX(FILTER(Table1,Table1[Year]=2020),Table1[Value])

Change = [2020] - [2019]

Change % = DIVIDE([Change],[2019])

Community Support Team _ Jing Zhang
If this post helps,please consider Accepting it as the solution to help other members find it.