Sum the Average of Averages per Category

[Anonymous]

Hi, 

I would like to take the average of each category and then sum them together without taking to total average. However, currently the sum is the total average. 

Currently this is my code: 

AVerage 4 = CALCULATE(

    AVERAGEX(

        SUMMARIZE( 'Test', 'Test'[category], 'Test'[Id]),

        CALCULATE( SUM( 'Test'[value) )

    ),  ALLEXCEPT( 'Test', 'Test'[Category])

)

I am trying to have the total be Average = 0 ´+ 1.71 + 22.88 + 0 +4.6

[amitchandak]

@Anonymous , Try like

AVerage 4 = CALCULATE(
AVERAGEX(
SUMMARIZE( 'Test', 'Test'[category]),
CALCULATE( SUM( 'Test'[value) )
), ALLEXCEPT( 'Test', 'Test'[Category])

)

or

AVerage 4 = CALCULATE(
AVERAGEX(
SUMMARIZE( 'Test', 'Test'[category]),
CALCULATE( SUM( 'Test'[value) )
)

)

[Anonymous]

Hi, 

It is still find the average for each category A,B,C,D,E  then for the "total" it is adding each average A, average B.... then dividing by 5. I would just like to to take the average of each category and add them togther 

Here is another measure I tried, that gives me the right averages but will not let me sum the values

Average =

CALCULATE(

    AVERAGE('Test'[Value]),

    FILTER ( ALLSELECTED ( 'Test' ), 'Test'[category] = MAX ( 'Test'[category) )

)

[Anonymous · Accepted solution]

Hi, 

Found a solution

Average 7 =

SUMX (

    VALUES ( 'Test'[Category]),

    AVERAGE ( 'Test'[Value] )

)