Can you help me pls?
I have the table
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?
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.