Value from table changes when displayed on Visual

[Mumiah]

I'm having this issue where I have a table shown in the Dashboard visual that the Time values differ from what's shown in power query, I think it's doing doing some odd rounding and as a result actually changes the value, it's a little odd to explain but hopefully the images below paint a better picture. 

First the expected result is Fig.1. The incorrect result I'm getting on the dashboard is Fig.2, this is almost correct but the row C , I and Total are incorrect. (Note the Total row isn't actually calculated it's a regular value)

 

Fig.1                    

Fig.2

The problem I think is there is a rounding that is being done on the visual that's not working properly, so I tried adding steps on Power Query for testing to dupicate the column convert it to Decimal number, and multiply it by 84600 to get the seconds and it would seem if we were to round these numbers this would actually output the correct numbers, even if the format it's displaying is completely not what I need

But even then if I try to make it a whole number it seems the I row dows not round the .5 either 

So I'm completely clueless as to how to address, again only reason I added those columns was for testing but what I need is for the dashboard to show the accurate seconds in it's Time format as once again shown below. any help truly appreciated and hopefully it all made sense. 

[Mumiah · Accepted solution]

So I was able to actually figure it out, on power query I converted the column to decimal numbers, then multiply it by 86400 and round it, but include "RoundingMode.AwayFromZero" this rounder the .5 up, (used this article Helpful Secrets about ROUNDing in Power Query - Excel Tips - MrExcel Publishing for reference), after it's been rounded, devided it by 86400 and convert it to Time, this looks a lot of steps and would still take a cleaner solution but it just might be a Bi Limitation.

[amitchandak]

@Mumiah , DAX is not best for duration sum.

Refer these option

Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[Mumiah]

So I'm not trying to do any type of sum, nor am I using duration, I'm just trying to get the dashboard visual to show the correct values as in the source file or in the Power Query.