Numeric fields not summed by default

[webportal]

When relating two tables by the year ("Ano"), the numerical fields, like Sales Amount are not added by default.
Instead they are counted, as if they were text fields.

So, when changing this to Sum in the report, I get "Sum of Sales Amount" in the legend instead of just "Sales Amount".

I know this is a detail, but I'm intrigued to find out why this happens.

Also, I'd like to know how can I change the legend to "Sales Amount" instead of "Sum of Sales Amount" in the chart below.

[sdjensen · Accepted solution]

I believe you are adding a column straing from your table to your visuals. Because when you do this you have many different options to how you want to display/calculate your number e.g as average, minimum, maximum ect. To avoid this you should calculate your values as measures and hide the origional colums from your table, so your users are not confured and use these instead of your real measures. You should consider the naming policy of you table column since you can't add a measure with a name already given to a column. So if you want a measure called 'Vendas e servicos prestados' you should rename the column in your table.

You could try this measure:

Vendas e servicos prestados = SUM('Financeiros'[Vendas e servicos pretados])

(sorry I don't have that special spanish (even more sorry if it's not spanish - I ment no offence) char)

[webportal]

Lol, it's Portuguese 🙂 it's a lot more beautiful, especially when it's sung.

Thanks for your help, I've also figured out that if I replace the year by a date, say 2007 by 31-12-2007, that column will act as a calendar and the agregation fields will be numeric by default.