Weighted Average per week and per month

[Anonymous]

In the callcenter is the AHT very important

we have AHT per day of each employee, but we need several measures:

1. Weighted Average per week per employee 

2. Weighted Average per month per employee

3. Weighted Average per week per team

4. Weighted Average per month per team

kind regards

[TomMartens]

Hey,

please provide the samle data from the embedded jpg as an excel file, upload the file to onedrive or dropbox and share the link.

Regards

Tom

[Anonymous]

https://www.dropbox.com/s/ybcq880qv96yljn/Weighted%20Average.xlsx?dl=0

[TomMartens · Accepted solution]

Hey,

thanks for uploading the sample data.

I created the following measures:

avg empl week = 
AVERAGEX(
    'Blad1'
    ,
    var currentName = 'Blad1'[Name]
    var currentWeek = 'Blad1'[Week]
    return
    CALCULATE(
        AVERAGE('Blad1'[AHT])
        ,ALL(Blad1)
        ,'Blad1'[Name] = currentName
        ,'Blad1'[Week] = currentWeek
    )
)

avg empl month = 
AVERAGEX(
    'Blad1'
    ,
    var currentName = 'Blad1'[Name]
    var currentMonth = 'Blad1'[Month]
    return
    CALCULATE(
        AVERAGE('Blad1'[AHT])
        ,ALL(Blad1)
        ,'Blad1'[Name] = currentName
        ,'Blad1'[Month] = currentMonth
    )
)

avg team week = 
AVERAGEX(
    'Blad1'
    ,
    var currentTeam = 'Blad1'[Team]    
    var currentWeek = 'Blad1'[Week]
    return
    CALCULATE(
        AVERAGE('Blad1'[AHT])
        ,ALL(Blad1)
        ,'Blad1'[Team] = currentTeam
        ,'Blad1'[Week] = currentWeek
    )
)

avg team month = 
AVERAGEX(
    'Blad1'
    ,
    var currentTeam = 'Blad1'[Team]    
    var currentMonth = 'Blad1'[Month]
    return
    CALCULATE(
        AVERAGE('Blad1'[AHT])
        ,ALL(Blad1)
        ,'Blad1'[Team] = currentTeam
        ,'Blad1'[Month] = currentMonth
    )
)

Here is a screenshot that is based on the sample data you provided:

Hopefully this is what you are looking for.

Regards,

Tom