Forum Discussion

JRego's avatar
JRego
New Member
6 years ago
Solved

Summarize VAR Calculated Table

Hello,    I'm struggling with DAX and especifically with how the Summarize function works. If you try to summarize a Calculated Table that previously was set in a VAR, you cannot use the columns fo...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    You just need a bit more DAX.

     

    Table 2 = 
    VAR __Table = CALCULATETABLE('Table')
    VAR __Table1 = SUMMARIZE(__Table,[Column1],"Sum",SUMX(FILTER(__Table,[Column1] = EARLIER('Table'[Column1])),[Column2]))
RETURN
    __Table1

    Attached PBIX below. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

You just need a bit more DAX.

 

Table 2 = 
    VAR __Table = CALCULATETABLE('Table')
    VAR __Table1 = SUMMARIZE(__Table,[Column1],"Sum",SUMX(FILTER(__Table,[Column1] = EARLIER('Table'[Column1])),[Column2]))
RETURN
    __Table1

Attached PBIX below. 

  • JRego's avatar
    JRego
    New Member
    6 years ago

    Thank you Greg 🙂 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago
      Happy to help! 🙂