Matrix - Measure Row Total

[sec12tst8r84]

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

[v-ljerr-msft · Accepted solution]

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