cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

## 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

1 ACCEPTED SOLUTION
Community Champion

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

Regards
Zubair

3 REPLIES 3
Community Champion

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

Regards
Zubair

Community Champion

@MiKeZZa

Regards
Zubair

Post Patron

Exactly what I was looking for!