Forum Discussion

ChenChristyYu's avatar
ChenChristyYu
Helper II
8 years ago
Solved

Create a new table using group by

Hi experts,

 

Here is a screenshot of my current table structure. I would like to create a new table based on this one, but the only group by periodID and CountryID_compcalc and ignore BankAccountTypeID, and sum up the counts. I tried to create a table, and the second pic is the result. Do you see any syntax error or any idea what problem it could be?

 

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi ChenChristyYu,

     

    Try the following code:

     

    Table =
SUMMARIZE (
    ALL ( Table[PeriodID]; Table1[CountryID]; Table[Count of payments] );
    Table[PeriodID];
    Table[CountryID];
    "Count"; SUM ( Table[Count of payments] )
)

    Just one question why are you creating a new table with the summary of Period, country and payments? You can make measures, and visual that based on context make this calculations wihtout having to duplicate your table.

     

    Just trying to help you achieve a better solution.

     

    Regards,

    MFelix

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi ChenChristyYu,

     

    Try the following code:

     

    Table =
SUMMARIZE (
    ALL ( Table[PeriodID]; Table1[CountryID]; Table[Count of payments] );
    Table[PeriodID];
    Table[CountryID];
    "Count"; SUM ( Table[Count of payments] )
)

    Just one question why are you creating a new table with the summary of Period, country and payments? You can make measures, and visual that based on context make this calculations wihtout having to duplicate your table.

     

    Just trying to help you achieve a better solution.

     

    Regards,

    MFelix