Forum Discussion

BIUser1998's avatar
BIUser1998
Icon for Helper I rankHelper I
2 years ago

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

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...
Need Help
Data-estDog's avatar
Data-estDog
Icon for Resolver II rankResolver II
2 years ago

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/1447523

 

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)