Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
thanks
Nick
Solved! Go to Solution.
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!
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
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!
Can't really get a sense of your data and such with this explanation but it sounds like you need to filter your Card visual or put some ALLEXCEPT type filters in your SUM statements via a CALCULATE. Hard to really tell what is going on from the information given.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |