PowerPivot CALCULATE SUM

[gavs1973]

Hi, would appreciate any help with this, In PowerPivot I'm trying to do a CALCULATE SUM similar to this in Excel...
I've tried EARLIEST in a FILTER but no success. Thanks in advance for any help. Gav

[attachment=0]powerpivsum.jpg[/attachment]

[rwfigtree]

calculatedcolumn=CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),Table1[Company]=EARLIER(Table1[Company]) && Table1[Date]=EARLIER(Table1[Date]) && Table1[Flag] = 1))+0