Forum Discussion

johnsmith92's avatar
johnsmith92
Regular Visitor
5 years ago

Rewrite SUMX? Poor performance when running calculations

Hi all,   I have the following table:   Queue AgentName Year Quarter Month Score1 Weight1 1 John 2021 1 January 100 6.87 1 John 2021 2 June 66,67 5.357 1 John 20...
Need Help
johnsmith92's avatar
johnsmith92
Regular Visitor
5 years ago

Thanks for the follow up, but if I'm not mistaken, what you suggest would end up evaluating the 

 

CALCULATE ( SUM ( FactScore[Score1] ) ) / CALCULATE ( COUNT ( FactScore[Score1] ) ) statement first

 

and this is my backup statement in case I have 0s in the weight column. But your suggestion of removing IFERROR has done wonders to my query. Now I just need to figure out the conditional calculation.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

As I said those were just examples to show the idea; statements and their sequence depend on your dataset and objective.