Sum of Average Value

[paul_jones]

I need to SUM the AVERAGE Machine Value of each Site for the Company.  In the sample below, it should return 250.  Any assistance would be appreciated.

Company	Site	Machine	Value
CA	S1	M1	100
CA	S1	M2	100
CA	S1	M3	100
CA	S2	M4	150
CA	S2	M5	150
CA	S2	M6	150

[v-yalanwu-msft · Accepted solution]

Hi, @paul_jones ;

Make a little modification.

AVG_SITE = SUMX(
    SUMMARIZE('Table', 'Table'[name], "1", AVERAGE('Table'[print_last_month])),
    [1])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[paul_jones]

PERFECT!  I needed MAX instead of AVERAGE but it worked flawlessly.  Thank you.

[Washivale]

Hi @paul_jones , Based on the data you provided and requirement answer would be 25637.5

to get this answer you would write following dax

AVG_SITE = SUMX(

    SUMMARIZECOLUMNS( 'Table (2)'[name], "GroupScore", AVERAGE('Table (2)'[print_last_month])),

    [GroupScore]

)

[Washivale]

Hi @paul_jones ,

check this out

AVG_SITE = SUMX(

    KEEPFILTERS(VALUES('TableTest'[Site])),

    AVERAGE(TableTest[Value])

)

Regards,

Washivale

[paul_jones]

Thank you for the reply.  Unfortunately, it did not return the correct value.  I think I need max instead of average which did not work either.  Below is actual data.  The answer should be 27836.

month	name	printer	print_last_month
April	Columbus	D103	6850
April	Columbus	D114	6850
April	Columbus	D126	6850
April	Columbus	D139	6850
April	Columbus	D144	934
April	Columbus	D377	6850
April	Louisville	D119	934
April	Louisville	D120	934
April	Louisville	D389	934
April	Grand Rapids	D140	1453
April	Grand Rapids	D260	1453
April	Jeffersonville	D232	2041
April	Indianapolis	D320	5482
April	Indianapolis	D321	5482
April	Indianapolis	D346	5482
April	Indianapolis	D578	5482
April	Indianapolis	D579	5482
April	Indianapolis	D580	5482
April	Nashville	D342	7717
April	Nashville	D390	7717
April	Des Moines	D388	934
April	Des Moines	D410	3359