Average of Avergae

[ps_twoo11]

Hi Everyone,

Hope you are doing well,

I am creating a model where I have to find average number of WFs done by individuals in a month , now I want to find average of all the averages that I calculated for them.

Thanks in advance.

[ps_twoo11]

Hi @sebastiandyrby , Thank y ou for you response, Currently I am using this DAX query to create a measure "= count(table[WF ID])/distinctcount(table[date])/(distinctcount(table[processor]) " it gives me correct value for an individual but what I want is, the average of all the averages derrived from above calculation.

Thanks,

[sebastiandyrby]

Hi again

It's a little hard to understand what you're doing without more information about the report or the dataset. But I imagine that you could take the average of your calculated measure using the AVERAGEX function; similar to what I did in the previous answer calculating the "MonthAverage"-measure.

[sebastiandyrby]

Hi

If I understand your question correctly, you can calculate the monthly averages with a FILTER function in a measure like this:

MonthAverage = 

VAR filteredTable =
FILTER(
    ALL('Table'),
    'Table'[Month] = SELECTEDVALUE('Table'[Month])
)

RETURN
AVERAGEX(
    filteredTable,
    'Table'[WFs]
)

Where I filter the table to only look at values for each month and then average my column of WFs. This might differ depending on the structure of your dataset. 

Next, I can simply take the average of these monthly averages like this:

Average of averages = 
AVERAGEX(
    ALL('Table'),
    [MonthAverage]
)

This yields the following results, where the left-most table is the sample dataset I used and the two measures. Next table is the monthly averages and the card shows the average of the monthly averages:

Hope this helps!