Forum Discussion

Anonymous's avatar
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:                             ...
  • az38's avatar
    az38
    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's avatar
Anonymous
Not applicable
6 years ago

az38 

 

Actually I want total orders done by only these riders:

 

 

 

 

 

 

 

 

 

Now counting the number of orders done by each of these 5 guys only is what I want.

 

Count of orders is a seperate measure:

Count Order = Count(Sheet1[OID])
 
So I want to know total orders done by only those 5 riders using above measure.
 
Hope I am able to convey my query
 
Thanks
az38's avatar
az38
Community Champion
6 years ago
Anonymous
You can just create a Riderrank column as you did it above
Then create a measure
measure = calculate(countrows(Sheet1), all(Sheet1), RiderRank<6)