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:

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ndna74,

Have you resolved your issue? If you have, please mark the right answer or helpful reply as answer. If you have not, you'd better share your sample table or screenshot for further analysis.

Best Regards,
Angelia