Currently I am using measures to attempt to calculate a utilisation rate based on the total working days & hours entered
At the moment the calculation for standard days varies as the data is drilled.. I need the data to be consistent that at all levels it just shows the information for the relevant period.
Standard Days = CALCULATE(DISTINCTCOUNT(Workload[Date]),all(Workload[Assignee]),Workload[BusinessDay]=True)
Standard Days with Workload = CALCULATE(DISTINCTCOUNT(Workload[Date]),Workload[BusinessDay]=True)
Any suggestions on update it so i get a measure which will adapt to the drilling on the date heirarchy?
I also tried
which gives me the total count of all the dates which are in the workload table but doens't filter it into the drilled / split data..
So in the above all engineers should have 21 in the standard days measure..
Go to Solution.
Add another filter ALL ( Workload[Team Leader] ) to CALCULATE Function as well.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.