Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @Cici ,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Best Regards,
Amy
Hi @Cici ,
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 Amy,
Thanks for your help! I tried the DAX below but there's an error that says:
"Too many arguments were passed to the ALLSELECTED function. The maximum argument count for the function is 1."
Hi @Cici ,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Best Regards,
Amy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |