March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
28 | |
19 | |
10 | |
8 |
User | Count |
---|---|
54 | |
42 | |
28 | |
11 | |
11 |