How can I only sum "last" values in a column?

[Domenick]

I want to sum the values in the [Indicator] column. In some instances, there are two values for the same [EndDate]. In those cases, I only want to include the latest [RunTime]. In the example below, both have a 1 in [Indicator] but there could be two 0s or a 0 and a 1. 

I am intending to divide this number by a DistinctCount of [EndDate] so that I can get a sort of % complete score across all EndDates (each EndDate only needs to be evaluated once but is sometimes evaluated twice when the end of the month falls in the middle of the week). Note that this table only shows one employee, but there will be several hundred employees in the full table.

[ryan_mayu · Accepted solution]

@Domenick 

maybe you can create a new column to flag the last record

iflast = 
VAR _max=CALCULATE(max('Table'[last modify date]),ALLEXCEPT('Table','Table'[last modify by],'Table'[date]))
return if(_max='Table'[last modify date],"Y")

[Domenick]

Thanks! This is a great ideas and it almost worked, but for some reason there are dates that aren't being flagged when they should. Any ideas?

I'm using the code you suggested but with the appropriate column names: 

iflast = VAR _max=CALCULATE(max(OAC_Timesheet_Citizenship[RunTime]),ALLEXCEPT(OAC_Timesheet_Citizenship,OAC_Timesheet_Citizenship[Emp],OAC_Timesheet_Citizenship[EndDate]))
return if(_max=OAC_Timesheet_Citizenship[RunTime],"Y")

[ryan_mayu]

@Domenick 

maybe there are duplicated data for emp and end date. 

try below to check why the max datetime is not different from the runtime datetime. The DAX returns the max runtime date for the same emp and same enddate.

iflast = VAR _max=CALCULATE(max(OAC_Timesheet_Citizenship[RunTime]),ALLEXCEPT(OAC_Timesheet_Citizenship,OAC_Timesheet_Citizenship[Emp],OAC_Timesheet_Citizenship[EndDate]))
return _max

[Domenick]

Ah yes, you are correct. I was able to easily filter those out, and now it all works. Thank you again!

[ryan_mayu]

you are welcome