Average Talktime in HH:MM:SS format

Hi Anonymous ,

Would you please refer to the measure below:

Measure =
VAR _Duration =
    AVERAGEX ( 'Table', 'Table'[Talktime_InSeconds] )
VAR Hours =
    INT ( _Duration / 3600 )
VAR Minutes =
    INT ( MOD ( _Duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
    ROUNDUP ( MOD ( MOD ( _Duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
    Hours * 10000 + Minutes * 100 + Seconds

Then change the data type to custom and 0:00:00 :

For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERNkGZGrCQxIs3eBOTeC0gMBo5mFaWB5fG_0p1D_m6CYLQ?e=bCpouF

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

Best Regards,

Dedmon Dai