It all depends on the use case. Power query is definitely good for pre calculation. You should not create a measure unless you are doing something dynamic. Sumx can be slow because of its iterative nature. However, there are scenarios that it can be really helpful.
Awesome video! Quick question. As SUMX is an iterator would it affect speed of visual loading and filtering? Would you advise then in this case either use more of the basic Sum type functions or in the table area of SUMX specify a more granular filter so that it doesn't iterate through every row.
It all depends on the scenario and the while calculation. Sometimes sumx can be slower because of its iterative approach. So calculate combination with sum might work better. However, sumx can be good to calculate totals in a Derived table...
Lol I agree with many comments here.
This is the best video explaining SUMX vs SUM.
This video should already blow up long ago 😂
I have watched so many videos on this topic but finally I understood.. your explanation is so good thank you
i realize I'm kind of randomly asking but do anybody know of a good site to stream new movies online ?
Best explanation on sum vs sumx. Thanks
I feel like this information should help me. A very important essential topic explained clearly.
very well explained.... understood it well!
Great explanation!
Raza, what's the difference between sumx and calculate? Thanks.
Sir, How to do summation of first 3 numbers in a series in power bi....?
Series: {5, 7, 2,3,9,10,2}
Desired sum: 5+7+2
Very nice! Well explained.
Hi Reza!
Is it true to refuse using SUMX because of memory misuse and using custom columns in power query as an instead. Which one is more efficient?
It all depends on the use case. Power query is definitely good for pre calculation. You should not create a measure unless you are doing something dynamic. Sumx can be slow because of its iterative nature. However, there are scenarios that it can be really helpful.
Awesome video! Quick question.
As SUMX is an iterator would it affect speed of visual loading and filtering? Would you advise then in this case either use more of the basic Sum type functions or in the table area of SUMX specify a more granular filter so that it doesn't iterate through every row.
It all depends on the scenario and the while calculation. Sometimes sumx can be slower because of its iterative approach. So calculate combination with sum might work better. However, sumx can be good to calculate totals in a Derived table...
Great Video
Glad you enjoyed it
Nice