Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Calculating difference between two time values column and finding its average

Hi Everyone, I need your help to solve a problem that I am facing. I have two columns which have time based value as shown in the picture: ...

6 years ago

Hi Anonymous

try a measure

Measure = format(calculate(averagex('Table',TIMEVALUE('Table'[Avg store reach time]))),"HH:MM:SS")

or

Measure = format(averagex('Table',TIMEVALUE('Table'[Avg store reach time])),"HH:MM:SS")

depends on business logic

Community Champion

6 years ago

Hi Anonymous

try a measure

Measure = format(calculate(averagex('Table',TIMEVALUE('Table'[Avg store reach time]))),"HH:MM:SS")

or

Measure = format(averagex('Table',TIMEVALUE('Table'[Avg store reach time])),"HH:MM:SS")

depends on business logic

Anonymous

Not applicable

6 years ago

Thank you for your help. It worked for me.

Is it ok if I can contact you for any future help?

az38
Community Champion
6 years ago
Anonymous

anytime. new threads, private messages, Linkedin.

the same about the Community - there are a lot of great users passionate to help you
- Anonymous
  Not applicable
  6 years ago
  az38
  
  Thank you so much for the support.
  
  Actually I am a little new to Power BI and hence facing another problem.
  
  I used the below measure to find the top 5 riders:
  
  Top 5 Riders = VAR RiderRank = (RANKX(ALL(Sheet1[Rider]), [Out The Door Time], ,DESC)) RETURN IF( RiderRank <=5, [Out The Door Time], BLANK())
  
  Now I want a measure by which I can find order count done by only these riders. Now order count in a different measure:
  
  Count Order = Count(Sheet1[OID])
  
  I am not knowing which DAX to use. Please help az38
  
  Thank you
  - az38
    Community Champion
    6 years ago
    Anonymous
    
    if I understand you correct you need a measure like
    
    C = calculate(countrows(Sheet1), ALLEXCEPT(Sheet1, Sheet1[Rider]))
    
    it will give you a countrows for each rider independ on his rank, so you can display it in visual without any additional actions from your side