Forum Discussion

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
8 years ago
Solved

Average of Average

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

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] )
)

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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] )
)