The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português