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.
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.
Solved! Go to 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.
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.
Hi @VipinReddy
Can you give a working example with sample data of what you want the expected result to be?
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))
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.
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.