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