Can't work with aggregates because Power BI not recognizing column as numeric data

[gordoncappo]

Ive dug through all the documentation and forum posts but can't seem to find a solution. Power BI will not recognize a column in my data as numeric which is preventing me from leveraging the aggregation features. 

Link to what I am talking about:  https://learn.microsoft.com/en-us/power-bi/create-reports/service-aggregates

I have done the following so far:

• Changed data type to type number in Power Query
• Data type on PBI desktop set to Whole Number
• Format on PBI desktop set to Whole Number
• Summarization set to Sum
• Running the February 2024 version of PBI Desktop.

I am not seeing the Numeric Field Sigma icon anywhere too.  It doesnt show up next to the column on Report View, Table View, or Model View. When I drag my "Value" column to a "Values" field in a visual, it does nothing. Below is a screenshot of what I see. Why is the Sigma symbol missing? Is this a setting issue?

[Idrissshatila]

Hello @gordoncappo ,

then there's a value im your field that is not a number that is preventing you from converting the column to an aggregate.

[gordoncappo]

Hi @Idrissshatila thank you for your response.

I don't know how that would be possible because there is no data error in power query and I can write a simple SUM formula on the column with no issue. Screenshot of the the column quality in power query.

[Idrissshatila]

@gordoncappo ,

if you can write a sum measure then what's the problem, you could write a measure to aggregate.

[gordoncappo]

I am wondering why it will not show the Numeric Field Sigma icon? Is there a setting I need to adjust?

[Idrissshatila · Accepted solution]

@gordoncappo , check this https://community.fabric.microsoft.com/t5/Desktop/Missing-Sum-Icon-in-the-table/td-p/1881045