Forum Discussion

Joak's avatar
Joak
Frequent Visitor
9 years ago
Solved

Summarize issue

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...
Need Help
Show and Tell
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    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] )
)
TomMartens's avatar
TomMartens
Super User
9 years ago

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's avatar
    Joak
    Frequent Visitor
    9 years ago

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

     

     

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      9 years ago

      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] )
)