Hello,
I'd like to subtract the difference between two rows within a matrix visual. In the case below, I want to subtract Gross Potential Rent and Rent to determine rent loss.
Is there also a way to subtract the total from two different visuals?
Thank you,
Sharlene
Hi @sec12tst8r84,
If [Gross Potential Rent] and [Rent] are two measures, then you should be able to use the formula below to create a new measure to calculate the rent loss, and then show it on the matrix or other visuals. 
Measure = [Gross Potential Rent] - [Rent]
Regards
Hi @sec12tst8r84,
If [Gross Potential Rent] and [Rent] are two measures, then you should be able to use the formula below to create a new measure to calculate the rent loss, and then show it on the matrix or other visuals.
Measure = [Gross Potential Rent] - [Rent]
Regards
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
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.
