Forum Discussion
Nested SUMMARIZE doesn't work with VAR?
Hey,
you should just use SUMMARIZE to group rows and add columns using ADDCOLUMNS(...), see here:
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Under certain circumstances it's still favorable to use ADDCOLUMNS(SUMMARIZRE(...),...) instead of SUMMARIZECOLUMNS, but the aritcle above is also mentioning this.
Not sure if this will help, but SUMMARIZE is an iterator, meaning maybe you should consider to wrap you expression into a CALCULATE(...) to enforce context transitiont.
Just wondering, without using your sample files
Regards,
Tom
Super UserHey,
you should just use SUMMARIZE to group rows and add columns using ADDCOLUMNS(...), see here:
https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/
Under certain circumstances it's still favorable to use ADDCOLUMNS(SUMMARIZRE(...),...) instead of SUMMARIZECOLUMNS, but the aritcle above is also mentioning this.
Not sure if this will help, but SUMMARIZE is an iterator, meaning maybe you should consider to wrap you expression into a CALCULATE(...) to enforce context transitiont.
Just wondering, without using your sample files
Regards,
Tom