• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


28 Nov, 2024

Updated at 02 Dec, 2024

SUM does not sum

Hi all,

 

I have a calculated value (calculated in power query, set as decimale value) and it shows the current values per row. Each row is unique.

However, when I sum that same value with the sum option (see printscreens below), it remains blank for some rows. Can anyone help me out? In the end I want to use the summarized value only but it does not show the correct amount and I think it is because of this.

 

The table with both values:

Anne_PBI_0-1732783060882.png

Settings of the first column set to "do not summarize":

Anne_PBI_2-1732783153818.png

 

Settings of the second column set to sum:

Anne_PBI_1-1732783092262.png

 

Many thanks,

Anne