Create a new table using group by

[ChenChristyYu]

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?

 

[MFelix · Accepted solution]

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