Running total in Calculated Column using multiple criteria

Hello Community,

I am trying to calculate the running total of a value based on 2 different columns, date and type. I have a measure that does this successfully for 2 different values, however, now I need to be able to compare the those 2 running totals to find which RT of value 2 is the closest to value 1. The problem that I have encountered is that I cannot use the MAX function on a measure, so I have been trying to recreate my running total on a calculated column to achieve what I need. 

The measures I have that work perfectly right now are:

RT Value1:= IF(SELECTEDVALUE(Table[DATE])
> calculate(
LASTNONBLANK(Table[DATE], 1),
FILTER(all(Table),Table[Value1] <> 0)),BLANK(),

CALCULATE(
SUM('Table'[Value1]),
FILTER( ALLSELECTED('Table'[DATE]), 'Table'[DATE] <= MAX(Table[DATE])
)
))

RT Value2:= CALCULATE(
SUM('Table'[Value2]),
FILTER(
ALLSELECTED('Table'[DATE]),
ISONORAFTER('Table'[DATE], MAX('Table'[DATE]), DESC)
)
)

This is the formula I am using for my Calculated Column that is not working:

RT Value1 Calc Column = IF(SELECTEDVALUE(Table[DATE])
> calculate(
LASTNONBLANK(Table[DATE], 1),
FILTER(all(Table),Table[Value1] <> 0)),BLANK(),

CALCULATE(SUM(Table[Value1]),FILTER(ALLEXCEPT(Table,Table[Type]), Table[DATE] <= MAX(Table[DATE]))))

Here is an example of my dataset:

Type in my dataset is the item type for each of of those values and dates, meaning, I need the running total calculated for each item based on the dates; as I change my filter from item 1 to item 2, etc, the new running total that comes up will be for that new item selected.

I have been trting different formulas based on Community posts regarding running totals for columns, but nothing has worked so far and I believe I have exhausted my search.

Thank you!