Forum Discussion

ccianci's avatar
ccianci
Frequent Visitor
3 years ago
Solved

average value ignoring filters

I need to get the average resolution time (for service desk tickets) for global staff.  I already got a working measure to calculate this average based on the employee name slicer.  I need a 2nd meas...
  • tamerj1's avatar
    3 years ago

    Hi ccianci 

    please try

    Avg Global Resolution Time All Staff =
    CALCULATE ( [Avg Global Resolution Time], ALL ( 'Table'[Staff] ) )