topic How to sum averages in DAX Commands and Tips

How to sum averages

pedroccamaraDBI — Mon, 02 Oct 2023 07:08:02 GMT

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

Re: How to sum averages

gaurav-lakhotia — Mon, 02 Oct 2023 07:47:27 GMT

Hi pedroccamaraDBI,

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

Re: How to sum averages

tamerj1 — Mon, 02 Oct 2023 07:53:39 GMT

Hi pedroccamaraDBI

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

Re: How to sum averages

Anonymous — Tue, 03 Oct 2023 01:44:39 GMT

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.

Re: How to sum averages

pedroccamaraDBI — Tue, 31 Oct 2023 08:42:19 GMT

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