How to Sum Aggregate values

[mic_rysel]

Hi please help me,
i need to sum average's values:

Column "Average of Puma Points" is averages automatically:

And i need to do column:

Year_month, SUM(AVG(Average of puma points))

but it doesnt work.

[Anonymous · Accepted solution]

For this you need a proper measure defined in DAX. Such a calculation is not possible via aggregations in GUI.

Here's something that should work for this particular scenario:

[Puma Points Average-Sum] :=
var __result =
	SUMX(
		ADDCOLUMNS(
			SUMMARIZE(
				T,
				T[Year_Month],
				T[TaskCode]
			),
			"avg", CALCULATE( AVERAGEX( T[Puma_points] ) )
		),
		[avg]
	)
return
	__result

Best

Darek

[mic_rysel]

Darek, You Are Great, it works!