Decimal Type Column behaving like text?

[campelliann]

Hi there, 

I am not able to place the field "Horas" (Hours" From table "Ausências" in the values area of the matrix visual - the data type is set as decimal. If I create a measure (sum Horas) works. I tried to summarize the field as "sum", but still does not work. I can solve this with a measure but would like to understand what is going on.

[campelliann]

@andhiii079845  it seems to be a bug according to this:

https://community.powerbi.com/t5/Desktop/Default-Summarization-Not-Working/m-p/1525159#M627476

[andhiii079845]

Very interesting problem. It is possible that you share this table from the PBI? 

[campelliann]

Hi mate, thank you for your reply. I cant sorry. But I copied the query to a new PBIX file and there it works. Perhaps something in the advanced options...

[andhiii079845]

Do you reopen the file, refresh all data...only a idea?