Bring last date if column A is greater than 0 (measure)

[Katie-Farrand12]

Hi all, 

I am trying to build a measure that shows the last date that we fed our livestock in a particular cage.

I wrote it like this: 

Last Feed Date = CALCULATE(LASTDATE('Calendar'[Date]), Filter(Actual,[Feed Kg]>0))

However I am just getting 31/3/2024 as a result for every column.  I want the table to look something like this:

Cage	Closed Date	Feed Kg	Last Feeding Date
1	20/9/2023	15000	19/9/2023
2	30/8/2023	16700	27/8/2023
3	29/7/2023	14900	27/8/2023

How do I tell the measure to look at each cage? Note: I can only add measures into the model, I cannot use columns

[lbendlin]

You already have the result you want.  Please clarify the question.

[Katie-Farrand12]

Good day @lbendlin 

I am getting result of 31/3/2024 for every single line. 

I want the last day that specific cage was fed, not the last day any cage was fed (or had planned feed). 

Warm regards,

Katie