Allocation of Hours

[VipinReddy]

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 in advance.

[v-yetao1-msft · Accepted solution]

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]

Hi @VipinReddy 

Can you give a working example with sample data of what you want the expected result to be?

[GilbertQ]

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]

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.