topic Re: Unexpected behavior with SUMMARIZE in DAX Commands and Tips

Unexpected behavior with SUMMARIZE

Jake_Neyu — Thu, 26 May 2022 11:09:50 GMT

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 :(.

Re: Unexpected behavior with SUMMARIZE

daXtreme — Thu, 26 May 2022 11:30:46 GMT

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.

Re: Unexpected behavior with SUMMARIZE

Jake_Neyu — Thu, 26 May 2022 16:09:10 GMT

Hi mate,

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

Re: Unexpected behavior with SUMMARIZE

daXtreme — Thu, 26 May 2022 16:43:04 GMT

All the secrets of SUMMARIZE - SQLBI