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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Remove the default SUM OF in variable aggregates

Hello! When I add a variable to my report it is given as a name SUM OF X THING and before that did not appear to me, only the added metric X COSA appeared without the SUM OF, and it is very annoying because I have to delete it every time I add something to a graph, before this did not happen, can it be modified or something? thanks for your help!

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@Syndicate_Admin Select the column in the Fields pane. In the Column tools tab of the ribbon, set the Default summarization to Do not summarize.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

I do not know how to do it, I can modify in the column tool, but I do not know how to modify it by default, when I add a new data modeling it is removed again

@Syndicate_Admin You can try going to File | Options and Settings | Options and under CURRENT FILE | Report settings all the way at the bottom uncheck the checkbox below Default summarizations. Otherwise, it's just something you have to do when you are creating a new data model or are adding data to a data model. It is one of the reasons I created Metadata Mechanic so that you could do this in mass. Check out the MSHGQM link in signature.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors