Forum Discussion
Numeric fields not summed by default
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)
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)
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.
