Hello
So I have stumbled upon a small problem with my pivot data and pivots. The data I have is a calendar with tasks to perform and each row have a task, person and departement labeled. I also have added a column that shows the monthly total hours for that person and this value is only shown once per month although the person can have multiple entries per month due to differing task labels. This setup creates a problem when I want to create a measure that shows the used capacity as a ratio. The second and onwards task label for the month will have 0 as the monthly capacity so the measure then returns error.
I need to someway be able to always return the monthly sum for the specific persons so that each task can also be calculated as a ratio to the monthly capacity. The current measure I have looks like this =SUM(TaskCalendar[Estimated time])/SUM([Monthly capacity Title]). I can have a new separate measure if it is needed.
So anybody have any idea on how to always get the single monthly value for the second argument?
So I have stumbled upon a small problem with my pivot data and pivots. The data I have is a calendar with tasks to perform and each row have a task, person and departement labeled. I also have added a column that shows the monthly total hours for that person and this value is only shown once per month although the person can have multiple entries per month due to differing task labels. This setup creates a problem when I want to create a measure that shows the used capacity as a ratio. The second and onwards task label for the month will have 0 as the monthly capacity so the measure then returns error.
I need to someway be able to always return the monthly sum for the specific persons so that each task can also be calculated as a ratio to the monthly capacity. The current measure I have looks like this =SUM(TaskCalendar[Estimated time])/SUM([Monthly capacity Title]). I can have a new separate measure if it is needed.
So anybody have any idea on how to always get the single monthly value for the second argument?