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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SKD1994
Regular Visitor

Aggregation is not enabled suddenly

The aggregation is not enabled suddenly I can't change the count to Sum or sum to count and even in the matrix table I can't add the numbers column to the value field.

 

SKD1994_0-1710258316215.png

 

3 REPLIES 3
Anonymous
Not applicable

HI @SKD1994,

What type of the value did the field stored? If they are text or data/time values which not able to be aggregated with math methods(e.g. average, sum, max/min), you should not be able to apply 'sum' mode on these type of fields.

In addition, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Sorry that's my org data and i'm not allowed to share the dashboard and this only happens in this dashboard only and I use the same datasets in new pbix file that aggregation enabled I have attached both the screenshot for your reference

SKD1994_0-1710493886728.pngSKD1994_1-1710493907551.png

 

The below are same datasets with new pbix file 

 

SKD1994_2-1710493975245.png

 

Anonymous
Not applicable

HI @SKD1994,

According to your snapshot, this field seems configured correctly. Did you worked with a custom visual? Does this scenario appeared when you use common power bi visuals?

If this issue only appears when you use custom visual, It should be a special visual issues. I'd like to suggest you contact to the visual author to report this scenario.

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors