Sum of in Reports

[dommyw277]

Hi, even though I want the Values to be a Sum, im sure this didnt happen before but now everytime i drag a value sum in, it says Sum of Jan, sum of Feb etc so I Have to rename for the visual. Is this new and/or is there a way round this? Thanks

[Anonymous]

It happens to me as well. One reason I find is limitations from calculation group.

Calculation groups in Analysis Services tabular models | Microsoft Learn：

Implicit column aggregations in Power BI are not supported for models with calculation groups.

---

[djurecic · Accepted solution]

Hi @dommyw277 ,

 It is a good practice to create explicit measures rather than use implicit measures. Here is additional information:

https://towardsdatascience.com/understanding-explicit-vs-implicit-measures-in-power-bi-e35b578808ca