Display seconds in hh:mm:ss format
Allow creating measures based on values in seconds (i.e AHT, Hold Time ,etc typical call center metrics), but display the result formatted as hh:mm:ss.
@Bill Hoenig: this approach does not work for larger numbers, e.g. TIME(0, 0, 86300) throws error (An argument of function 'TIME' has the wrong data type or the result is too large or too small.)
Bill Hoenig commented
You can use the TIME function to get the results you want. For example: lets say you have a measure called [Average time in seconds] that returns 195.6. You can then do this:
AverageTime:=TIME(0, 0, [Average time in seconds])
Then format the measure with a Custom format of HH:mm:ss
The above will show 00:03:16. The actual value is a datetime of 12/30/1899 00:03:16
Note: At the time of this writing the DAX engine has a bug in the FORMAT function. So if you used mm:ss, in Power BI, the format function thinks you wanted MM:ss, which is month : ss (returning 12:16 and very misleading). If you put the HH before the mm, then the format function seems to know that you want minutes. I personally didn't want hours and my minutes were always less then 10, so I used Hm:ss as a workaround for this bug.