Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Missing Sum Icon in the table

Hi,

 

For some reason, I lost the Icon of sum in my tables for all numeric fields.

 

fabnishi1207_0-1622770931573.png

 

 

This is how it was before:

 

fabnishi1207_1-1622770966839.png

 

Any idea how to fix it?

 

Thanks!

 

 

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

The icon in front of fields with numeric type appears when the option Summarization under Column tools tab is set as any of aggregations(Sum/Average/Minimum/Maximum/Count/Count (Distinct) ). When it set to Don't summarize, the icon will be disappear... Please check whether the Summarization of these numeric fields also be set to Don't summarize.

yingyinr_0-1623053523336.png

yingyinr_1-1623053851871.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
storgall
Frequent Visitor

I had the same problem, but both my Data type and Format were set to a Decimal number and Summarization was at Sum. My problem was Tabular Editor, when you create a calculation group, it sets DiscourageImplicitMeasures to True, which disables summarization. To turn it back on, remove any calculation groups, go to Tabular Editor, click on Model, and set DiscourageImplicitMeasures to False. Or you can use measures to do summarizations (which should be a better way).

 

Thank you! This was my problem as well.

This should be the solution. Saved me big time.

This was very helpful, thank you!

v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

The icon in front of fields with numeric type appears when the option Summarization under Column tools tab is set as any of aggregations(Sum/Average/Minimum/Maximum/Count/Count (Distinct) ). When it set to Don't summarize, the icon will be disappear... Please check whether the Summarization of these numeric fields also be set to Don't summarize.

yingyinr_0-1623053523336.png

yingyinr_1-1623053851871.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@Anonymous , Go to Power Query/ Transform Data.

 

Under Transform Data Table, There is an option detect data type. Click that for the table and save and exit and try

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

The data types are correct.

 

It didn't work.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.