SUM of MAX values in SUMMARIZE function

[Midguel]

Hi!

I think i'm missing some DAX function, i have this code for a calculated table:

SUMMARIZE('produccion chat y ret','produccion chat y ret'[C-OP],'produccion chat y ret'[N-COLADA-O],'produccion chat y ret'[W-Q-TONELA-O],"fecha mov",MAX('produccion chat y ret'[Fecha MOVTO]))

and is returning me this table (filtered to be more clear): 

and i wanted to SUM the tons for the MAX date of my table so i tried this code:

SUMMARIZE('produccion chat y ret','produccion chat y ret'[C-OP],'produccion chat y ret'[N-COLADA-O],"fecha mov",MAX('produccion chat y ret'[Fecha MOVTO]),"tns",SUM('produccion chat y ret'[W-Q-TONELA-O]))

but it's returning me the total sum:

it should only sum the first two rows with date of 26/08, how can i reach this result?

Thank you for your help!

[Greg_Deckler]

@Midguel - I'm thinking:

Measure = 
  VAR __Table = 
      SUMMARIZE('produccion chat y ret','produccion chat y ret'[C-OP],'produccion chat y ret'[N-COLADA-O],'produccion chat y ret'[W-Q-TONELA-O],"fecha mov",MAX('produccion chat y ret'[Fecha MOVTO]))
  VAR __MaxDate = MAXX(__Table,[fecha mov])
RETURN
  SUMX(FILTER(__Table,[fecha mov]=__MaxDate),[W-Q-TONELA-O])

[Midguel]

Hi, thank you for your answer, i noticed that this is for a new measure but i'm trying to create a new calculated table, is there a way to do use this DAX but in a calculated table format?

Thank you again for your help.