Forum Discussion

RVBIBS's avatar
RVBIBS
Regular Visitor
3 years ago

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