How to sum averages

[pedroccamaraDBI]

Hello everyone
I have a simple measure that calculates the average:

Net Cost Detail AVG =

AVERAGEX( 'Product Cost Detail', 'Product Cost Detail'[Net Cost Detail])

I would like to have at the end of the visual the sum of all those values

My Net Cost Detail measure is a simple SUM of a column

Thank you all in advance

[Anonymous · Accepted solution]

Hi @pedroccamaraDBI ,

According to your statement, I think [Net Cost Detail AVG] is a measure, so it will work when you add it into a visual. The result of measure is based on the key columns in your visual, so I suggest you to try SUMX() function based on [Net Cost Detail AVG].

New Net Cost Detail AVG =
SUMX (
    SUMMARIZE ( 'TableName', [KeyColumnName1], [KeyColumnName2],... ),
    [Net Cost Detail AVG]
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pedroccamaraDBI]

Hi @Anonymous 
I'm so sorry for this  (very) late reply  and thank you so much for your help

[tamerj1]

Hi @pedroccamaraDBI 

that depends on the visual itself i.e. over which column are you calculating the the average? Can you paste a screenshot?

[gaurav-lakhotia]

Hi @pedroccamaraDBI,

Try this - SUMX('Product Cost Detail', AVERAGE('Product Cost Detail'[Net Cost Detail]))