cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jake_Neyu
Frequent Visitor

Unexpected behavior with SUMMARIZE

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

 

Jake_Neyu_0-1653563250169.png

 

1 ACCEPTED SOLUTION
3 REPLIES 3
daXtreme
Super User
Super User

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.

Hi mate,

 

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors