Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Averagex dax not working for lower level data

Hi Experts

 

I am trying to calculate the Average Net Margin using the following dax.

 

AV Net Margin = Calculate(Average(Values(Product[global]), [Net Margin (%)]), All(Customer),All(Report Region)

 

When i add material id and material description which the next level down to my table to work out the Av Net Margin with next level data - the dax give me an incorrect values...

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Fixed dlit the calcukate is in the wrong place should come before Net Margin