Sum values from visible rows grouping based on another column

Hello,

I aim to show sum of values from one column (AMT_COL) grouped on another one (ID_COL) as new column (SUM_COL).

I have created SUM_COL using following formula:

TestCalculation = SUMX(FILTER(Table1;Table1[ID_COL] = EARLIER(Table1[COL_ID]));Table1[AMT_COL])

However it gives me sum of all grouped rows, even those that are currently filtered out (I filter on DATE_COL).

Any tips how to include that visibility aspect to my formula?

Thanks in advance.

Mike