Forum Discussion
Data showing incorrect Capacity number
Hi Guys,
I am trying to create a Demand and Capacity visual chart in Power BI for resources per month. I already have the data for both. However, the capacity numbers appear to be incorrect especially for those resources assigned to multiple Projects as it was showing duplicate numbers per Project. Now, when I create a chart, it sums up the Capacity numbers which throws off the data in my chart.
By the way, I used 2 tables to compute for Capacity and below is the measure that I used:
| Resource Name | Project Name | Month | Demand | Capacity |
| Onshore | Proj-A | January | 100 | 160 |
| Onshore | Proj-B | January | 30 | 160 |
| Onshore | Proj-C | January | 30 | 160 |
| Offshore | Proj-A | January | 80 | 180 |
| Offshore | Proj-B | January | 30 | 180 |
| Offshore | Proj-C | January | 30 | 180 |
| Offshore | Proj-D | January | 40 | 180 |
I hope you could help me and provide a solution for this. Thank you!
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Best Regards,
Amy
4 Replies
Hi Anonymous ,
Try to create column Capacity using DAX below.
Capacity =CALCULATE( RELATED(RM_Roster[Work Hours]) * RELATED(Calendar_Workdays[Number of Working Days]),FILTER(ALLSELECTED(Table1),Table1[Resource Name]=EARLIER(Table1[Resource Name])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You may miss brackets in measure, find it and try it again.
Best Regards,
Amy