Using PowerPivot I am struggling to create a measure to do the following: I have a bunch of projects that people book time to. Hours are booked to either capex or opex tasks. I can create measures to compare time booked to capex or opex. What I would like to do is: Filter out all the projects that have time booked to them over a certain threshold in month (say > 500 hours); Add up all those hours; Then to see how much they contribute the capex total. Is that possible? Can someone point me in the right direction? I have dimension tables for the projects, the tasks people can book to; a calendar of course, and a fact table with the time people booked.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sum If total as share of overall total.

Thread starter Lapwing
Start date Sep 15, 2017
Tags

booked capex people projects time

Lapwing

New Member

Sep 15, 2017

[FONT=&quot]Using PowerPivot I am struggling to create a measure to do the following:[/FONT]
[FONT=&quot]I have a bunch of projects that people book time to.
Hours are booked to either capex or opex tasks.
I can create measures to compare time booked to capex or opex.
What I would like to do is:[/FONT]

Filter out all the projects that have time booked to them over a certain threshold in month (say > 500 hours);
Add up all those hours;
Then to see how much they contribute the capex total.

[FONT=&quot]Is that possible? Can someone point me in the right direction?

I have dimension tables for the projects, the tasks people can book to; a calendar of course, and a fact table with the time people booked.
[/FONT]