Forum Discussion
substract sum with single value
Please post the exact measure you are using - looks like yours is missing parentheses.
Assuming you are using a Dates table you may be summing up the same billable hours for each day of the week, thus overstating the value by a factor of 7 (or 6 if you want to be a math stickler). So you may need to use AVERAGE or MAX instead of SUM.
Is this what you mean?
Measure = CALCULATE(SUM('importfile'[Aantal])) - CALCULATE(SUM(target[targethours]))
( i replaced the original because it contaisn company names)
Your second CALCULATE likely needs to use AVERAGE, not SUM.
Hard to help without good sample data.
Hi,
I've recreated the file with sample data. Couldnt attach it in a post so uploaded it to WeTransfer https://we.tl/t-5uHyzX6SLm
I want to have the value of the Mease show = (sum of Aantal) - targethours
so in this case:
Employee 1 worked 41,25 hours that week while target is 8, so + 33,25
Week 1 Week 2 Employee 1 33,25 42,25 Employee 2 24 25,5 Employee 3 20 20