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.

Anonymous's avatar
Anonymous
Not applicable
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.

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

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