Forum Discussion
Using summarize gives wrong value
Hi Anonymous
The below article explains how Summarize works, the common practice is to use summarize for group by and then ADDCOLUMN() for Aggregations.
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi Anonymous
The below article explains how Summarize works, the common practice is to use summarize for group by and then ADDCOLUMN() for Aggregations.
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the article!
It makes perfect sense now.
Although it seems Summarizedcolumns seems to be amore efficient way to use this.
Will look into it