I have a Q that is suppose to be very easy:

I am trying to sum only the latest quantities in each project on every site. 

I.e. Find the latest quantities for site USA and project A and sum it.

I am struggling to create a measure/ calculated column in PP.

Thanks.

I don't think that you are thinking in measures just yet. Create a measure that sums quantity. Create a pivot table or a matrix in Power View that shows site, item, date and your measure, sort by date. Or, leave date out of it, I'm not sure exactly what you are looking for as an end result. For example, in the case you site, do you want 23 or 13? You can always filter by date.

A measure will calculate the formula you give it but CONSTRAINED by the values in the row that it is on.

• Edited by Seth Moupre 10 hours 7 minutes ago

Maybe it is that trivial, but I don't know the dates... I want to show the latest of each project...

Is your suggestion still valid to this problem?

Thank you

Excel 2010 with free PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
Filter on latest Revision.
http://www.mediafire.com/view/dq3s0z28w4cjm60/07_11_15.xlsx

I think the following will do what you are after:

SumOfLatest:=calculate(sum(Table1[Quantity]),FILTER(Table1,Table1[Revision]=MAX(Table1[Revision])))

Worked like a charm!!

THANKS

Can you tell me what have I done wrong? I tried the same thing for about a day :)

My first try was:

A:=CALCULATE(SUM([inches]),MAX([File Date])=[File Date])

My 2nd try was a bit like yours, but I placed the MAX () before the statement and got an error...

I placed MAX() first, does PP can't understand that syntax? 

....FILTER(Table1,MAX(Table1[Revision])=Table1[Revision]))

Appreciate if you can clarify why my statements couldn't be used, so it will be a case study for me :)

• Edited by 5 minutes ago