Applying an adjustment to a value of a matrix table dynamically

[Lancelot]

Hi All

I have a requirement to apply a manual adjustment to a value on a matrix table dynamically.

I have used a what-if parameter to caprute the value. I also have a sclicer that allows to select which row to apply the adjustment to.

However, after doing all this, the adjusted values is applied across the entire matrix table. i am not sure what I am doing wrong. Please see below:

Steps:

1. Select the record to apply an adjustment to

2.  Select the amount to adjust it by

3. If you look at the adjusted Value card, that is the correct value

4. However, on the matrix table, all records have been adjusted by 1mill when only data should have been adjusted

[Lancelot]

New Total Amount =
var _standardCat = SELECTEDVALUE('Trial Balance'[StandardCat])
var _analysisCat2 = SELECTEDVALUE('Trial Balance'[AnalysisCat2])
RETURN
var _results = IF(_analysisCat2 <> BLANK() && _standardCat <> BLANK(),
CALCULATE(-1 * SUM('Trial Balance'[Value]) + 'Manual Adjustment'[Manual Adjustment Value],
FILTER('Trial Balance','Trial Balance'[AnalysisCat2] = _analysisCat2),
FILTER('Trial Balance','Trial Balance'[StandardCat] = _standardCat)),
SUM('Trial Balance'[Value]))