Sum of average of group of sum of single value of group

[Anonymous]

Hi all,

In the picture below there are id's and their size. I'd like to sum all the sizes of each I'd without grouping in Power Query. I'm thinking about two possibilities but correct me if I'm wrong. 

1. Choosing one size for each id and sum them 

2. Adding all Sizes for every id and dividing them by the amount of id's

The total must be 10 however and also when adding rows to a matrix.

Thanks in advance!!

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Try these two measures, please.

Measure =
SUMX ( DISTINCT ( 'Table1' ), [Size] )

Measure 2 =
SUMX ( SUMMARIZE ( 'Table1', Table1[_ID], Table1[Size] ), [Size] )

Best Regards,
Dale