Measure - Sum table by earliest date?

[Anonymous]

So I have a basic table. One column called Amount and one column called date. The earliest date in the table is 10/1/19. The sum of amount for 10/1/19 is 200. Why does the below measure not equal 200 but sums the entire table?

Test = CALCULATE(SUM('Table1'[Amt]),FILTER('Table1',MIN('Table1'[Date])))

[Anonymous · Accepted solution]

That was easy. Needs to be as follows:

Test = CALCULATE(SUM('Table1'[Amt]),FILTER('Table1','Table1'[Date]=MIN('Table1'[Date])))