Apply that filter to context so it is apply first in Tableau Order of Operations
After filter, your last value is that of 18th.
see LAST() documentation here: Table Calculation Functions
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...