Calculate with sum of items

[Wresen]

Hi and thx for reading this.

I have a table below and i want to make a Measure that calculates the SUM of each Item divided by the count if The item and show it on Month.

ex.

Item A sum = 25 , it is 2 items, 25 /2 = 12,5

Item B sum = 40, it is 3 items, 40 /3  =13,3

item C Sum = 45, it is 2 items, 45/2 =22,5

The mesure should show.

202310  25,8

202311  22,5

/Thanks for any help.

[Fowmy · Accepted solution]

@Wresen 

Use this measrue:

MaeasureName = 
SUMX(
	ADDCOLUMNS(
		SUMMARIZE( table , table[month] , talble[item] ),
		"Avg" , 
			CALCULATE( AVERAGE( table[value ) )
	),
	[Avg]
)

[Wresen]

@Fowmy 
Thanks so much for the help 🙂