How to simulate a price change and show it in a chart

[nor303]

I have a issue that Im trying to solve. Im suppose to stress a loan portfolio. We are using LTV as one measure, Loan/value. But Im not able to do this in powerbi desktop and show in a clusterchart how the customers will move between different categories when the value of their property changes. Any ideas on how to solve this would be great! See example data:

					Change in Value -10%	Change in Value -15%	Change in Value -25%
					0,90			0,85			0,75
Loan	Value	LTV			Value	LTV		Value	LTV		Value	LTV
10	20	50 %			18,00	56 %		17	59 %		15	67 %
20	25	80 %			22,50	89 %		21,25	94 %		18,75	107 %
50	80	63 %			72,00	69 %		68	74 %		60	83 %
70	100	70 %			90,00	78 %		85	82 %		75	93 %
40	55	73 %			49,50	81 %		46,75	86 %		41,25	97 %
20	35	57 %			31,50	63 %		29,75	67 %		26,25	76 %
210

And I need something like this as outcome (but in chart)

LTV		50-60%	60-70%	70-80%	80-100%	Above 100%	Total
Loan tot		30	50	110	20	0		210
Loan tot - 10%	10	70	70	60	0		210
Loan tot - 15%	10	20	50	130	0		210
Loan tot - 25%	0	10	20	160	20		210

Thanks!

[ToddChitt]

Can you add columns for [Value minus 10%] = [Value] * 0.9 and [Value minus 15%] = [Value] * 0.85, etc.?

Then different measure for LTV-10, LTC-15, etc.?

What am I missing?

[nor303]

Yes I can calculate the different columns but what kind of measures do you mean I should make? Thanks!

[ToddChitt]

The measures would simply be the sum of each of those new columns respectively.

Pro tip: technically, you do not need measures for simple sums as pretty much every visual will assume the aggregation is a SUM for Value columns, but I like to do it anyway.

[nor303]

How will the code for the different measures look?