What is summarization setting in Power BI?

< 1 min read

Summarization setting in Power BI defines how a column is aggregated by default in visuals.
It controls options like Sum, Average, Count, Distinct Count, or Do Not Summarize.
This setting is configured in the data model.
For example, Sales Amount is set to Sum by default.
Unit Price is set to Do Not Summarize to avoid incorrect totals.
In one project, wrong summarization caused price values to be summed across rows.
After correcting the default summarization, reports showed accurate results.
Setting it properly ensures consistent behavior when users drag fields into visuals.

Power BI Essentials