Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Lover55
New Member

Comparing Values in Matrix

HI, I am trying to compare two values in a table, with the output being the difference in the two values. I have a filter which will compare two different column values with the same field for value and want to know the difference within that table as an output. I appreciate any assistance.
2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Lover55,

 

You can simply try a measure like below.

 

Mesure =
SUM ( 'table'[column1] ) - SUM ( 'table'[column2] )

Please try "CTRL + F5" to refresh the browser and then upload an image again.

 

It's better to share some sample data that we can copy or download. 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lover55
New Member

I am new to this, and am trying to share a screenshot of my data to clarify this question, when I click on "Insert Image" it just has an empty box for "source" how do i upload an image from my computer?

 

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.