Forum Discussion
RVBIBS
3 years agoRegular Visitor
Total is incorrect
I'm trying to make a very simple production cost of a product based on costs and items made.
At the moment my measure is:
AS_COST = CALCULATE(SUM(AS_Combined[Total hours])*140/SUM(AS_Combined[Made]))
Where 140 is my running costs pr. hour.
The results are correct, but my total isn't:
For example Day 18: 0,09 +1,05 + 0,26 isnt = 0,2. or the average isn't 0,2.
I have read something about using SUMX, but doesent seems to fit it into my data.
No RepliesBe the first to reply