Average of distinct ID - two columns

[Anonymous]

I need have a measure made that gives me average of days.

I have a column wiht ID and a column with days spent,

Example

UID                DAYS       

1                    32

2                    5

2                    5

4                    15

5                    33

6                    12

6                    12

8                    5

9                    5

10                  15

Average should be 15.25

I have tried the following solution http://community.powerbi.com/t5/Desktop/Average-based-on-distinct-values-in-another-column/m-p/60122...

But doesnt seem to work for me 😕

[MattAllington · Accepted solution]

How about this

=Averagex(values(table[UID]), average(table[days]))

[Anonymous]

Thanks Matt, I have tested 2 periods and looks like it works - Thanks a lot

[MattAllington]

Do you know how it works?

Averagex is an iterator.  It steps through a table - in this case it is a single column table containing all the unique UIDs created by values(table[UID].  For each unique UID, the formula average(table[days]) is evaluated.  Assuming each unique UID has the same value for [days], the average will be the same as the value.  After each UID has been evaluated, AVERAGEX works out the average of the values.