I have a Job Activity Table, containing recorded working time, service type, and building type etc data.
To me, it's sort of three dimension.
- one is time recording
- two is service type
- three is building type
Under the time recording, we have Project with Unique Project Number (One and Only)
Group up, Project with the Unique Project Number belongs to certain Phase;
Structure down, Project contains Tasks;
Tasks will be done by different Labours;
Labours record their working time against Tasks, per day;
In parallel, each Project has another two parameters: Service Type and Building Type (we number the project per building, so each project/building will only have one building type associated)
I calculate the average time consumption %, to use it as a bench mark for analysing under each phase, different project performance. It works.
I use the same priciple try to get an average time consumption % of all phase, then analyse for each phase performance, compare to the average of all phases. But couldn't make it.
I also want to set up bench mark of Service Type, get an average time consumption % for different Service Type.
Need some help/tips.
If someone can further explain difference between filter All, Allselect, and Allexcept, that's even better.
Here is the shared Power BI Report.
https://app.powerbi.com/groups/me/reports/7f7d8deb-dfdd-4b7c-a687-847301567f4b?ctid=f0b08376-6d02-45...
Here is the same file on google drive can be downloaded.
https://drive.google.com/open?id=1u6kVcfiYmmuTd6C_7xK5v7xYkHZL3tux
