Excel DAX Measure need to return same value for every instance

[RodrigoFinguer]

Hello there,

I have a table below, and I have calculated a measure using power pivot to return the status of the tag number of the last date.
But my current dax formula returns the value for every row, but I need to return if the tag number in the last date is deleted or not.

Tag Number	TAG STATUS	DATE	DAX CALCULATE (WHAT I HAVE)	DAX CALCULATE (WHAT I NEED)
302806	RELEASED	14/10/2021​	RELEASED	DELETED
302806	RELEASED	20/10/2021​	RELEASED	DELETED
302806	DELETED	20/10/2021​	DELETED	DELETED

My formula:

=CALCULATE(MAX([Tag Status]);FILTER(Tag_Base;[Tag Number]=[Tag Number]&&[Date]=MAX([Date])))

Any solution? I couldn't find anything!
Thanks!!