Powerpivot Formula - Summarize column from another Table

[citizenbh]

Excel 2013 - Power Pivot
How add column which summarize column from another table in power pivot relationship one to many:

Table 1

IdT1 Name1T1 AmountT1
1 A 1000
2 B 1500
3 C 1000

Table 2
IdT2 IdT1 AmountT2
1 1 200
2 2 500
3 1 400
4 3 300
5 3 350
6 2 450
7 1 100

ResultTable (Table1 with summarize Column)

IdT1 Name1T1 AmountT1 Sum(AmountT2)
1 A 1000 700
2 B 1500 950
3 C 1000 650

 

[citizenbh]

Eureka! I found the solution:

=CALCULATE(SUM(T2[AmountT2]), FILTER(T2,T1[IdT1]=T2[IdT1]))

 

[Salle]

Hi,

You could also use SUMX(RELATEDTABLE(Table2),[AmountT2]).

/Daniel