Forum Discussion

sec12tst8r84's avatar
sec12tst8r84
Frequent Visitor
8 years ago
Solved

Matrix - Measure Row Total

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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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. :smileyhappy:

    Measure = [Gross Potential Rent] - [Rent]

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

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. :smileyhappy:

Measure = [Gross Potential Rent] - [Rent]

 

Regards