Hi Andrew,

You're almost there!  You just need to compare the Exercise date (in your viz this is already at the Facility > Type of Exercise > Building Floor level of detail) against the max date that you already calculated.  If the dates match then return the exercise score.  Here's the calc (including the piece you already wrote):

if [Date of Exercise] = { FIXED [Facility],[Type of Exercise],[Building Floor]: MAX(DATE([Date of Exercise]))}

then [Exercise Score]

end

Hey Andrew - did this work out for you?  If so, can you mark my answer as correct, and click "yes" for "This Helped Me"?

If you have any questions about the solution though, let me know.

Best,

Paul