Forum Discussion
souvik900766
Helper IV
4 years agoSubtotal issue using summarize and sumx
Hi, My measure using sumx and summarize showing values at market level 0. I wanted to add all the market numbers to get the OU total ,the markets are coming zero and OUs also My OU and Market come...
smpa01
Community Champion
4 years agosouvik900766 the rule of thumb is not to use any aggregation inside SUMMARIZE as it is really complex.
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/