Unexpected behavior with SUMMARIZE

[Jake_Neyu]

Hello,

In the measure 'AR total avg', I use 2 variables, 'ar_source' and 'agent_validate'

At lowest level of the hierarchy, variable 'ar_source' shows total leads of each source.

On the next level of the hierarchy, variable 'agent_validate' shows the sum of total leads of all sources.

However, variable 'agent_validate' shows 54893 leads which is incorrect, the correct number is 96512 (sum of total leads of all sources calculated by variable 'ar_source')

Please help me with this case :(.

[daXtreme]

You should never perform any calculations in SUMMARIZE in measures. SUMMARIZE is such a complex function (in terms of behaviour) that Alberto Ferrari and Marco Russo strongly advise against performing calculations within it (they themselves never do it). Please, instead use the combination ADDCOLUMNS/SUMMARIZE. SUMMARIZE must only be used for grouping, nothing else, if you want to stay sane.

[Jake_Neyu]

Hi mate,

Thanks for your advice, do you have any idea how I can apply ADDCOLUMNS with this case?

[daXtreme · Accepted solution]

All the secrets of SUMMARIZE - SQLBI