Error fetching data for the visual

Hi AntBI26 ,

You can modify the formula you provided at the beginning by replacing the hours minutes and seconds directly with the split down fields:

TotalTimeFormatted1 = 
//VAR TimeString1 = [TimeActivities]
VAR Hours1 = MAX('YourTable'[TimeActivities - Copy.1])
VAR Minutes1 = MAX('YourTable'[TimeActivities - Copy.2])
VAR Seconds1 = MAX('YourTable'[TimeActivities - Copy.3])
VAR TotalSeconds1 = (Hours1 * 3600) + (Minutes1 * 60) + Seconds1

//VAR TimeString2 = [TimeActivities2]
VAR Hours2 = MAX('YourTable2'[TimeActivities - Copy.1])
VAR Minutes2 = MAX('YourTable2'[TimeActivities - Copy.2])
VAR Seconds2 = MAX('YourTable2'[TimeActivities - Copy.3])
VAR TotalSeconds2 = (Hours2 * 3600) + (Minutes2 * 60) + Seconds2

VAR TotalSeconds = TotalSeconds1 + TotalSeconds2
VAR Hours = TRUNC(TotalSeconds / 3600)
VAR Minutes = TRUNC(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN
FORMAT(Hours, "00") & ":" &
FORMAT(Minutes, "00") & ":" &
FORMAT(Seconds, "00")

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.