Incorrect Row Totaling in Table Visualisation | Forum

Hi Akash,

Thank you for your forum question. My name is Ron and I am one of STL's trainers.

Akash, I tried to replicate the data you used in your example and I get the 621 as a result.

I created both a new column so you can see the values and created a measure that also gave 621 as a result.

I attached a workbook and a Power Bi report based on your sample data which shows you the results.

I have no idea why your visuals in Power Bi give you the wrong result.

If Power Bi gives you the wrong result in the visual I would go back and have a good look at the source data. Are there maybe additional values in the source data that you were not aware of. Are there values in Table A that might have no related records in table B?. Are there duplicate values in any of the tables Because I am almost sure that that is the reason for the odd result.

Please reply to this message if you have anything additional to add and more importantly if you do find out the reason for the error. Please let us know that too?

I hope this answers your query.

Kind regards

Ron Oldeboom
Learning and Development Consultant at STL -training

Please double check

Hi Akash,

I just realised you are rounding up. The rounding up on each individual row may be the issue.

Try rounding the end result rather than rounding up each individual row because that might be where the issue lies. Instead of using roundup() try formatting the measure to display 0 decimals and see if it changes your end value. Mine was altered to 622 which is the accurate rounded value based on your data.

Please let me know if that was the issue.

Kind regards

Ron Oldeboom