Sum average columns values in Sub Totals on Matrix visual

[lucashmcury]

hi guys,

I am using one Matrix visual, as per below image, with column "Category" in Coumns, Values column in Values and Company in rows

But the Column Sub Total is showing me the average of all columns...and I need the sum

Below is the dax formula I am using to get the average by each column

Average of Values average per Company Names =

    AVERAGEX(

    KEEPFILTERS(VALUES('Company'[Names])),

    CALCULATE(AVERAGE('Values'[Values]))

)

How can I set the Column Sub Totals to show the sum of all columns averages? 

[tamerj1 · Accepted solution]

Hi @lucashmcury 
Please try

Average of Values average per Company Names =
VAR NormalAverage =
    AVERAGEX (
        KEEPFILTERS ( VALUES ( 'Company'[Names] ) ),
        CALCULATE ( AVERAGE ( 'Values'[Values] ) )
    )
VAR SumOfAverage =
    SUMX (
        VALUES ( 'Table'[Category] ),
        CALCULATE (
            AVERAGEX (
                KEEPFILTERS ( VALUES ( 'Company'[Names] ) ),
                CALCULATE ( AVERAGE ( 'Values'[Values] ) )
            )
        )
    )
RETURN
    IF ( ISINSCOPE ( 'Table'[Category] ), NormalAverage, SumOfAverage )

[lucashmcury]

thank you!

you are a master!