DAX measure duration (hh:mm:ss)

[llyons]

Hello, I am a beginner learner of Power BI and having an issue with duration formatted hh:mm:ss. I have customer service Power BI table. I have serveral formated columns as duration. I need to be able to create a measure for a few durations

Below is the custom column I use in excel power query how can I do this in Power BI:

   CallsAnsIn30=Value.Divide(Value.Multiply[ANS],[#"%SL']),100) 

   TotalSpeedtoAnswer=Value.Multiply([ANS],[ASA])

    ASA = TotalSpeedtoAnswer/ANS

   SL% = CallsAnsIn30/ANS

Also, I have serveral duration I need to average  ex. for average handle time. I can do this in excel power query but don't know how to do in Power BI as the row I need to average are not available to create an average.

any help would be greatly appreciated, Thank you, Lily

[Greg_Deckler · Accepted solution]

Sample data would help, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But it sounds like you want something like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

[llyons]

Again, please forgive me as I am a new user to Power BI.

below is the measure I am using. How do I get the answer of my average to show in Visualizations as hh:mm:ss?

Talk = (AVERAGE(fTransactions[Talk.0]))

an example,  the answer of the above measure is 346 . I need the 346 formated as 00:05:46 in any one of the Visualizations.

Thank you in advance for your help