Using a dimension to filter a measure

Hi everyone,

I am trying to slice a measure below based on the category .

The measure is Total Amount (works perfectly) and it calculates (Running total) "Total Amount" for an item and assigns it to the most recent category based on the Transdate (as filtered by the slicer) .

The dax is shown below:

----------------------------------------------

Total Amount =
VAR __cat = MAX( 'Table'[Category] )
VAR __summary =
CALCULATETABLE(
ADDCOLUMNS(
ADDCOLUMNS(
SUMMARIZE(
'Table',
'Table'[ITEMID],
'Table'[WarehouseID]
),
"@amt", CALCULATE( SUM( 'Table'[Amount] ) ),
"@maxdate", CALCULATE( MAX( 'Table'[TRANSDATE] ) )
),
"@Cat",
VAR __dt = [@maxdate]
RETURN
CALCULATE(
MAX( 'Table'[Category] ),
'Table'[TRANSDATE] = __dt
)
),
ALLSELECTED( 'Table'[Category] )
)
RETURN
IF(
__cat IN SELECTCOLUMNS( __summary, "_cat", [@Cat] ),
SUMX( FILTER( __summary, [@Cat] = __cat ), [@amt] )
)

However when i try to use a slicer (category) to interact with my measure  the value changes.

i have a dataset below :

https://www.dropbox.com/scl/fi/8cqz36yc44brmf2rzre7w/MATDW-SAMPLE-DATA_v2.xlsx?dl=0&rlkey=jzgswrfhetei13u8j7ucmfltv

My current challenge is when i try to use the category as a filter , the results change to a wrong value . 

Pic 1: The results are perfect without the category filter :

Pic 2: Wrong values when i include the Category Filter . The values should remain the same as above.

Thanks for your help in advance ,it is appreciated.

v-janeyg-msft