Forum Discussion
Post PartisanHow to sum averages
Hello everyone
I have a simple measure that calculates the average:
Thank you all in advance
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pedroccamaraDBIHi Anonymous
I'm so sorry for this (very) late reply and thank you so much for your help
gaurav-lakhotiaHelper I
Hi pedroccamaraDBI,
Try this - SUMX('Product Cost Detail', AVERAGE('Product Cost Detail'[Net Cost Detail]))- tamerj1
Community Champion
that depends on the visual itself i.e. over which column are you calculating the the average? Can you paste a screenshot?
