Forum Discussion
Matrix shows all projects for each resource
Hi, for security reasons i had to blur most information. So I have a Matrix at the bottom of the page. Here i want to visualize the workload per ressource. If you open the Resource by clicking ...
Hi, ray_aramburo
thank you for your answer so far.
This is the Code for "CAP".
CAP = sum(ResourceTimephased[Capacity])
The capacity column displays the capacity per resource per workday in hours.
The capacity column displays the capacity per resource per workday in hours.
ray_aramburo
Super User
Super UserIt is strange that it's the same for everyone. Do your values and rows come from different tables? Now it seems more like a relationship issue.
well, since CAP resembles the Capacity for a Resource per day, no it is not unusual to be the same for every resource. But certainly there are differences. E.g. on weekends the capacity is 0. and for people who do not work fulltime, the capacity may also be reduced (or higher in other cases).
- ray_aramburo
Is it possible for you to share your .pbix file or a sample of your data?