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 BankAccountT...
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

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