Forum Discussion
Matrix shows all projects for each resource
The reason that happens is because you have a measure (I'm guessing is the CAP one by observation) that returns an outcome for every row, thus you end up having that 6.40 in each row/project. Please share the logic behind that.
For the meantime, if you remove it, you'll get a temporal fix.
Other temporal solution which I don't fully recommend as there might be valid cases, is for you to filter the matrix with the filters pane for your matrix to include all values where the Actuals field "is not blank".
Hi, ray_aramburo
thank you for your answer so far.
This is the Code for "CAP".
The capacity column displays the capacity per resource per workday in hours.
It 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).
Is it possible for you to share your .pbix file or a sample of your data?