How to calculate average time?

[Anonymous]

Hi,

How to do "total time" / "total users" = average time? My goal here is to get an average time per user. 

The Time I have is in decimal form. I created a measure and turn them into "hour" : "min".

Measure I have: Time = FORMAT(AVERAGE('xxx'[Time on page]),"nn:ss")

Then, I tried to use the measure to divide users. It won't allow me to do that.

Then I tried to use the decimal numbers to divide users, it returned 0.

Avg time = DIVIDE (SUM('xxx'[Time on Page]), SUM('xxx'[Users]),0)

Please help!

[Anonymous]

Hi @Anonymous ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌😀

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

Not very clear about your expected output... But if you want to display the same average value on each row,please try:

Measure = CALCULATE( AVERAGE('Table'[Time on Page]),ALLSELECTED('Table'))

Or please provide more details to help us clarify your scenario.

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

[Greg_Deckler]

@Anonymous Chelsie Eiden's Duration - Microsoft Power BI Community

[Anonymous]

@Greg_Deckler  I am not sure how the article going to solve my issue here. Can you please tell me how can I get the average "mm:ss" instead of 0? Thanks!

[Greg_Deckler]

@Anonymous You can't divide using the measure because it is text. So, if you use Chelsie Eiden's Duration and keep the number as a number (don't use FORMAT) then you could use the measure.

[Anonymous]

@Greg_Deckler  The column "time on page" is in decimal. How can I change these decimal numbers to seconds? Thanks a lot!