Forum Discussion
ROUND & SUM issue
Hi, That's might sound lame but I have a problem doing a simple sum on some of my datas ! At first I added a new column on my table with the following DAX formula : = CALCULATE (SUM([price])+...
Anonymous I doub't there would be anything wrong in the way power bi sums it. To troubleshoot it you will have to drill down to lower levels. Can you drill down to month's level and check with sql query on your source. The only thing I can think is why you need to use CALCULATE fuction. For your calculated column you can simply create it as, SUM([price])+SUM([tax]). See if that makes any difference.