Forum Discussion

yestrada74's avatar
yestrada74
Regular Visitor
2 years ago

Sales per Unit Calculation

I have all values in the same column, including costs for each cost element (Group Accounts) across time and volume accross time. I am trying to get each cost element per unit of volume with this formula but it's not working:  

 
CALCULATE ( SUM ('Historic Values'[Value] ) , 'Historic Values'[Group Account] = "Plant Reported Volume" )
 
What am I doing wrong?