Sum average by Date

[RookiePBI2019]

Hi all,

I would need some help with a specific DAX formula that it is getting me crazy.

I need the sum of average by date and WH of the following table:

Date	WH	Total Lines
13/05/2019	ALBACETE	223
13/05/2019	ALBACETE	223
13/05/2019	ALBACETE	223
13/05/2019	ALBACETE	223
13/05/2019	ALBACETE	223
20/05/2019	ALBACETE	150
20/05/2019	ALBACETE	150
20/05/2019	ALBACETE	150
20/05/2019	ALBACETE	150
13/05/2019	ALICANTE	456
13/05/2019	ALICANTE	456
13/05/2019	ALICANTE	456
13/05/2019	ALICANTE	456
13/05/2019	ALICANTE	456
20/05/2019	ALICANTE	56
20/05/2019	ALICANTE	56
20/05/2019	ALICANTE	56
20/05/2019	ALICANTE	56

The result that I am expected is sum both days average by WH:

ALBACETE	373
ALICANTE	512

I hope somebody can help me.

Thanks in advance!

[parry2k · Accepted solution]

@RookiePBI2019 here is the measure for you

Sum of Avg by Date and WH = 
SUMX( 
SUMMARIZE( Table1, Table1[Date], Table1[WH] ),
 CALCULATE( AVERAGE( Table1[Total Lines] ) ) 
)

[RookiePBI2019]

Thank you so much! It works perfectly!