Easy Tech TutsHow to Change Count to Sum in Power BI (Quick Aggregation Fix) Easily 2026
By Impran M N
It's a common early mistake: a numeric field gets added to a visual and Power BI defaults to counting rows instead of summing the actual values. This guide shows how to quickly change that aggregation from Count to Sum. It's a small fix, but one that matters a lot for anyone relying on accurate totals in sales, inventory, or financial reports.
01Navigate the Power BI interface
Click on the visual showing the incorrect aggregation and locate the field in the Values well of the visualizations pane.
02Change Count to Sum
Click the dropdown arrow next to the field in the Values well and select Sum from the list of available aggregation types.
03Apply best practices for data visualization
Double-check that the field is truly numeric, since text or ID fields will only offer count-based aggregations rather than sum.
04Verify the corrected totals
Compare the new summed value against a known total from your source data to confirm the aggregation change produced accurate results.
Frequently asked questions
Why did Power BI default to Count instead of Sum in the first place?
Power BI often defaults numeric fields imported in certain formats, or fields it interprets as identifiers, to Count rather than Sum until you manually change it.
Can I set the default aggregation for a field so I don't have to fix it every time?
Yes, in the Data view you can select the column and change its default summarization setting so new visuals use Sum automatically going forward.
Does changing Count to Sum affect other visuals using the same field?
No, changing the aggregation within a single visual only affects that visual, unless you change the column's default summarization at the model level.
Why is the Sum option grayed out for my field?
This usually means the field is stored as text rather than a numeric data type, which needs to be corrected in Power Query before Sum becomes available.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
