Summarize issue

[Joak]

Hello, 

In a new table, I want to summarize a column; and then sum the values that are matching together : 

ExistingTable-

Column A              Values

A                                2

A                                2

A                                4

B                                1

B                                 1

B

New Table-

Column A            Values

A                              8

B                              2

I'm Using this code : 

New table = SUMMARIZE(
' ExistingTable ' ;
' ExistingTable ' [Column A] ;
Sum ( ' Existing Table ' [Values] )

I'm wondering why wouldn't that be working ? 

Thanks 🙂

[TomMartens]

Hey,

I guess your Table-Calculation should look like this

New table = SUMMARIZE(
  ' ExistingTable ' ;
  ' ExistingTable ' [Column A] ;
  "Values", Sum ( ' Existing Table ' [Values] )
)

It seems your formula just missed a column name for the aggregated value.

And for a couple of reasons it also a good practice to take this article into account:

http://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

Hope this helps

[Joak]

Thanks, you're right it works now thanks for the highlight and the article ! 

[v-chuncz-msft · Accepted solution]

@Joak,

You may use GROUPBY Function as well. By the way, to help close this thread, accept the solution above. Your contribution is highly appreciated.

New table =
GROUPBY (
    ExistingTable,
    ExistingTable[Column A],
    "Values", SUMX ( CURRENTGROUP (), ExistingTable[Values] )
)