How to sum values on a Unique ID and add to ID Table

[nft25]

I have Table 1 (which lists Group sizes and which ID that group belongs to).

ID	GroupSize
1	10
1	5
1	20
2	25
2	3

I'd like to sum groupsize by ID and insert the result to Table 2 (the ID table) like so:

ID	TotalGroupSize
1	35
2	28

I have a 1 - * relationship from Table 2 -> Table 1. 

[camargos88 · Accepted solution]

Hi @nft25 ,

Try this for a new table:

Table 2 = SUMMARIZE('Table'; 'Table'[ID]; "TotalGroupSize"; SUM('Table'[GroupSize]))

Ricardo

[AlB]

Hi @nft25 

If the relationship is through ID, you can create a calculated column in Table2 as:

TotalGroupSize = SUM(Table1[GroupSize])

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers 

[nft25]

@AlB This summed every group in Table 1 together irrespective of ID.

[AlB]

Hi @nft25 

You need a calculate to trigger context transition:

TotalGroupSize = CALCULATE(SUM(Table1[GroupSize]))

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers