Forum Discussion

GarnseyG's avatar
GarnseyG
Icon for Helper I rankHelper I
6 years ago

Measure from two tables

I have one table containing the names of different tasks and a field called Window that define a number of days. Table is call Tasks and has three elements, Task, Job, Window.   A second table iden...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

GarnseyG's avatar
GarnseyG
Icon for Helper I rankHelper I
6 years ago

This works for the individual tasks, but not for projects. Three of the four have the same percentages for each task (projects P1, P2, and P4) so the project level numbers are correct I think only because of this. But project P3 is wrong. There are 8 people who have reported time (yes some are the same person in different tasks but that doesn't matter) and 4 have time within the window. Project p3's percent should be 50%.

 

In total, 20 people (again the fact it was the same person in different tasks is not important) reported time and in 13 cases they were in the window, so 65%.

 

Hopefully this better explains it all. I do very much appreciate your working on this!!!