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/
- souvik9007664 years ago
Helper IV
smpa01 any way, what to use instead
- smpa014 years ago
Community Champion
souvik900766 provide sample data, expected output
- souvik9007664 years ago
Helper IV
Hi smpa01
Here is the file,
Kindly help, urgently needed.
https://www.dropbox.com/s/7oq1viv0f7of033/Total%20error.pbix?dl=0