Sigma symbol is missing, I can't summarize

[inm]

Hello.

I don't know what is happening. I can't summarize any column, sigma symbol is missing and I have summarize option selected. Does anyone have an idea how I can make the symbol appear so I can summarize?

These columns are number types and still sigma symbol is missing.

[inm]

@negi007  Yes, I already have the measure, the thing is that I want to do it the other way because I have many measures and I think that that way it takes longer while it is calculated. I want to decrease the waiting time.

[PaulDBrown]

@inm 

I have never, ever, used the default "summarize" value for a column. In fact, I make a point of turning them all off. It is actually considered a "best practice" I believe. 
Use measures instead.

[negi007]

@inm Then can you try to change the data type in the power query window like below. This way your data will flow in number format in powerbi desktop

[inm]

@negi007 thank you for your answer. My data type is Whole Number in power query too. I don't understand why it's not working.

[negi007]

@inm I hope you do not have any null/text/special character values in your data. is it possible for you to share the data for this particular column.

[inm]

@negi007 I have checked it and I don't have any special/null/text data. When I loaded the data at first it appeared to me, I was adding things to the report and it stopped appearing the symbol. This is not happening in just that column, it's happening in every whole number column.

[negi007]

@inm pl. share your data if you can in text/excel file. Can't comment anything without looking at the data.

[Greg_Deckler]

@inm Just have to make sure it is not text. I have seen it where the sigma symbol does not appear but you can still sum it like a number.