Use this formula instead:

=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(Taulukko1[[#All],[id]],Taulukko1[[#This Row],[id]],Taulukko1[[#All],[value]]) + SUMIF(Taulukko2[[#All],[id]],Taulukko1[[#This Row],[id]],Taulukko2[[#All],[value]]),"")

(changes in red). It will show the totals only on the first row of any ID.

Hope this helps.

Pete