Forum Discussion

NoordenNL076's avatar
NoordenNL076
Regular Visitor
4 years ago
Solved

Calculating over average instead of row value

Hello,   I'm trying to calculate the total volume of a product by multiplying the volume of that product * quantity. The problem is that it is calculating the volume over the total average of all p...
Need Help
Show and Tell
  • johnt75's avatar
    johnt75
    4 years ago

    You could try

    Max cap. over period cm3 = AVERAGEX('Dimensions per material', 
'Dimensions per material'[Volume]*'Calculations'[New Max QTY] )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could try

Max cap. over period cm3 = AVERAGEX('Dimensions per material', 
'Dimensions per material'[Volume]*'Calculations'[New Max QTY] )
  • NoordenNL076's avatar
    NoordenNL076
    Regular Visitor
    4 years ago

    Thank you, John. It worked ğŸ¤˜