Compare two matrix tables from the same data table and show percentage difference

[BIUser1998]

I have created two matrix table visualizations from the same data table and I want to show the percentage difference between each value in a third table. How do I achieve this? I am new to PowerBI so this is something that is quite new to me. Any leads would be appreciated. Thank you

[v-zhangti]

Hi, @BIUser1998 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Data-estDog]

You've been super vauge, with no data and no examples. Do this going forward: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

But I'll take a shot in the dark:

Create a measure subtracting each of the corrisponding columns. If matrix 1 is for 2022 and matrix 2 is for 2023, and one of the columns is total sales. Create a measure with the following definition:

Measure = calculate(sum(totalsales), year = 2023) - calculate(sum(totalsales), year = 2022)