Forum Discussion

VipinReddy's avatar
VipinReddy
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Allocation of Hours

Hey,  Above is the sample data that is available. I want to allocate 100hours for each resource which should be divided equally. The output I am looking for is as follows.    Thank you...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi VipinReddy 

    (1)Create a column with fixed value “100” .

    Hours = 100

    (2)Calculate the numbers of rows in [Resource] with a column .

    count number = CALCULATE(COUNT('Table'[Task]),ALLEXCEPT('Table','Table'[Resource]))

    (3)Create a column to return the value Allocate Hours .

    Allocate Hours = 'Table'[Hours]/'Table'[count number]

    Then add these columns in a table visual .

    You can see the result ,you can hide the Hours and count number in the visual .

    I have attached my pbix file ,you can refer to it .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi VipinReddy 

 

Do you want this in the column or as a measure?

 

If it is a measure you could do the following:

 

Allocated Hours = DIVIDE(100,COUNTROWS(TableName))
VipinReddy's avatar
VipinReddy
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

I have multiple resources in my data. I want 100hours to be allocated to each of these resources and divide equally by the number of tasks.