cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DECOVIOTI Regular Visitor
Regular Visitor

Average of Average

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?

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Average of Average

Hi @DECOVIOTI,

 

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:

 

w1.PNG

 

You can create a measure below:

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

 

w2.PNGw3.PNG

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.