Forum Discussion
substract sum with single value
Hi all, I'm new with Power BI so please don't shoot me as i'm trying to understand the functions 🙂 We are building an Power BI Dashboard where we calculate how many billable hours the employ...
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