Return Diff Value from Min Calculation DAX

[rsj88]

Hi,

I have the below Dax Calc:

Result = CALCULATE(
MIN(Table1[DateTime]),
FILTER(Table1,Table1[ID]=EARLIER(Table2[ID])
&& Table1[Colour] IN {"Red"})

This works fine and returns the mindate from Table1. However I want this to calculate the min date Then return the value from Table1[Model] instead of the date.

Any ideas?

Thanks in Advance.

 

[mart37]

Result = CALCULATE(
SUM(Table1[Model]),
FILTER(Table1,(Table1[DateTime] = MIN(Table1[DateTime])
&& Table1[ID]=EARLIER(Table2[ID])
&& Table1[Colour] IN {"Red"})