Average of Average

[MiKeZZa]

Hi all,

I'm having trouble while making an 'average of an average'. I see many people asking this here, but I can't find anything that solves my problem....

I'm having this data:

What you see is a table with: employees have records per day, most of the time 1 record. When they have more than 1 function/role in the organization there are more records (like emp_id 3). 

Now I want to calculate the duration of a sickness. I have this:

But I want for the total this:

3.5 + 1 + 7 = 11.5, based on 3 persons so total is: 11.5/3= 3.83 and not 4.4.

So it must be the average of the average per person. How can I do this?????

 PBIX-file with these data and Measure is here: https://ufile.io/g96mu

[Zubair_Muhammad · Accepted solution]

Hi @MiKeZZa

Create a new MEASURE as follows which will refer your original MEASURE

Measure 2 =
IF (
    HASONEFILTER ( emp[Name] ),
    [Measure],
    AVERAGEX ( ALLSELECTED ( emp[Name] ), [Measure] )
)

[Zubair_Muhammad]

@MiKeZZa

[MiKeZZa]

Exactly what I was looking for!