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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

It does not summarize one table while another does

Hello

I am currently making a dashboard for my company. This dashboard was started before and I am continuing to develop it.

The problem is that the same table, with the same measurement and everything exactly the same, the sum of the data that I have put for a column is made, however, this table was the one made by my predecessor:

Adrialanon_0-1752740108757.pngAdrialanon_1-1752740127194.png

However, if I try to do the same for another table, it does not add correctly, but puts one by one several data that I have for that column. The thing is, I need to do this for several different columns since I'm using multiple filters. And if I compare it with any other table I try to make, I don't get that 'Sum of' even though it's the same measure and it's already summarized.

Adrialanon_2-1752740248198.pngAdrialanon_3-1752740263830.png

In this case you can see how the 'Sum of' that I need does not appear in the column inserted in the table. Please, any to

5 REPLIES 5
v-sgandrathi
Community Support
Community Support

Hi @Syndicate_Admin,

 

Has your issue been resolved?
If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.


Thank you.

Hi @Syndicate_Admin,

 

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

 

Thank you.

MFelix
Super User
Super User

Hi,

 

It's seems to me that the use of implicit measure has been disable on your model because of the use of calculations groups or similar.

 

Go to the Model view and on the right pane select Model and then select semantic model chekc if you have the option discourage implicit measure turn on:

 

MFelix_0-1752742303377.png

This feature disable the use of columns and the aggregations using the context button that is why you are seeing all the values instead of the sum. All the visuals created before this feature is turned on keep the aggregation.

 

Keep this option turned on  and create a new measure with the SUM(Table[Column]) and use it on your visual.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hello

Yes, that was thank you very much!!

Don't forget to accept the correct answer so it can help others.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.