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 Internal'[Rate]) +'Rate change'[Rate change Value]) When I change the rate on the what-if slider, the yield per loan increase/decrease is correct but the overal increase/decrease for the portfolio is not. This is because when I put this measure into a card, the calucation mutiplies the sum of all amounts with the sum of all rates. Does anyone know how I can rectify this? thanksNick

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: