Calculated Max Date Column Filtered by Category

Good morning i´m trying to create a max column to set the following condition:

if the max date is the max date from the store, put a flag Y

In a measure i did this and worked well, but the user need use this flag as filter.

the measure created:

Flag Visited :=

VAR datemax = CALCULATE(MAX('Date'[Date]),FILTER(ALL('Execution Audit KPI'),'Execution Audit KPI'[Audit Store SK] = SELECTEDVALUE('Execution Audit KPI'[Audit Store SK])))

VAR flag = IF(datemax = SELECTEDVALUE('Date'[Date]) ,"Y","N")

return

flag

What i need: create the same condition done by measure but by a calculated column

My try:

flagnova =

var maxdate = CALCULATE(

MAXX(

SUMMARIZE('exec audit','exec audit'[Audit Store SK]),MAX('exec audit'[Start Date SK])

),ALLEXCEPT('exec audit','exec audit'[Audit Store SK]))

return  

IF(maxdate = 'exec audit'[Start Date SK] ,"Y","N")

 

Results from my try

 

It almost worked, but instead to do the max date per month he did the max date in a day level.

 

 

 

 

Table Model example:

 

 

Could you guys help me with this ?

 

Att.