Forum Discussion

ndna74's avatar
ndna74
Frequent Visitor
9 years ago
Solved

What-if / measure

Hi all   I've created a measure (below) that calculates loan yield that can be adjusted with a what-if parameter (rate change)   Rate adjust = SUM('_Portfolio Internal'[Amount])* (sum('_Portfolio...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    To get the correct value in the Total Row (or when in a Card) use this Measure instead

     

    Rate adjust =
SUMX (
    '_Portfolio Internal',
    '_Portfolio Internal'[Amount]
        * ( '_Portfolio Internal'[Rate] + 'Rate change'[Rate change Value] )
)

    SUMX will perform this per row and then add those results - instead of first summing each column

     

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

To get the correct value in the Total Row (or when in a Card) use this Measure instead

 

Rate adjust =
SUMX (
    '_Portfolio Internal',
    '_Portfolio Internal'[Amount]
        * ( '_Portfolio Internal'[Rate] + 'Rate change'[Rate change Value] )
)

SUMX will perform this per row and then add those results - instead of first summing each column

 

Hope this helps! :smileyhappy: