Forum Discussion

pedroccamaraDBI's avatar
pedroccamaraDBI
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

How to sum averages

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 ...
Need Help DAX
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

gaurav-lakhotia's avatar
gaurav-lakhotia
Icon for Helper I rankHelper I
2 years ago

Hi pedroccamaraDBI,

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