Matrix: Monthly Grand total for Project Timeline

[Anonymous]

I'm using the project timeline that Mr. Will Thompson posted some times ago. 

It's very useful to me. And I'm looking forward to having the grand total & subtotal. 

It just doesn't sum up the headcount(manpower) monthly. Instead, it only picks up the max number of that columns.

Any guru have any idea how to resolve this? Here's my pbix file.

[Anonymous · Accepted solution]

Hi @Anonymous 

Here is the solution.
Change the measure to this and you will see the total.

Stage Text = 
var selectedDate = SELECTEDVALUE(Dates[Date])
var projectsBetweenDates = FILTER(Projects, Projects[Start Date] <= selectedDate && Projects[End Date] >= selectedDate)
var numberProjects = COUNTROWS(projectsBetweenDates)
var projectState = CALCULATE(MIN(Projects[Stage]), projectsBetweenDates)
var headcount= IF(SELECTEDVALUE(Projects[Description])="",CALCULATE(SUM(Projects[Manpower]),projectsBetweenDates),CALCULATE(MAX(Projects[Manpower]),projectsBetweenDates))
return IF(projectState<>"", headcount, " ")

Find the pbix attached after signature.

[Anonymous]

@Anonymous , it works perfectly! Didn't know it's so easy!

Thank you for being so helpful.