Forum Discussion
yestrada74
2 years agoRegular Visitor
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?
1 Reply
- parry2kSuper User
yestrada74 It will be easier if you share non-sensitive data with the expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490