Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 espec...
General Comment
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Best Regards,

    Amy

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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."

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    You may miss brackets in measure, find it and try it again.

     

    Best Regards,

    Amy

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Best Regards,

    Amy