Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SUM of MAX values in SUMMARIZE function

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!

Calculatetable
column calculation
SUM of MAX
SUMMARIZE

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - 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])
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.