Average lead time

Hi  Anonymous ,

Using your oringinal data "Seconds" for calculation would be better.

Create 2 measures as below:

average = AVERAGEX(ALLSELECTED('Table'),'Table'[Seconds])

format = 
var _hour=INT('Table'[average]/3600)
var _min=INT(DIVIDE('Table'[average]-_hour*3600,60))
var _sec=INT('Table'[average]-_hour*3600-_min*60)
Return
_hour&":"&_min&":"&_sec

And you would see:

For my related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!