Average of Average

[Anonymous]

Hello Guys

Can you help me pls?

I have the table

Month AVG_Time 

 1         154

 2         126

 3         128

 4         159

I would like to know the average of the following AVG_Time, but the problem is the quantity of months are variable, depending how many months i selected in the slicer

is there a way to calculate this measure?

[v-qiuyu-msft]

Hi @Anonymous,

You can use Summarize() function to get a summarized table with a new column contains AVG_Time values(154,126,128,159), then embed Summarize() function within AverageX() function. 

As I don't know your sample data and how the measure AVG_Time defined, I show the sample with some dummy data:

You can create a measure below:

AvG = AVERAGEX(SUMMARIZE('Table1','Table1'[Month],"AVG",AVERAGE('Table1'[Amount])),[AVG])

You can download the attached pbix file to have a look. 

Best Regards,
Qiuyun Yu