cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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

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:

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

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.