Explanation of summarize formula

[Anonymous]

Hello,

I have read about the summarize formula but it doesn't yet make sense to make.

Can you give an example of when summarize may be used perhaps with an example?

Appreciate your help

[v-cherch-msft · Accepted solution]

Hi @Anonymous

Summarize Function can be used to get a summarize table. Below are some articles and posts for your reference.

https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

https://www.sqlbi.com/articles/all-the-secrets-of-summarize/

https://community.powerbi.com/t5/Desktop/Measure-to-calculate-percentage-of-Low-spend/td-p/547500

https://community.powerbi.com/t5/Desktop/How-to-use-DAX-to-Sum-sales-and-take-the-average-per-transaction/m-p/493955#M230258

Regards,

Cherie