Forum Discussion
Dax Query optimization
Hello, Below query is for Total Sum of the positive values in tablur report, working as expected but liitle slow. How to rewrite it in optimize way? Correct Total Sum = SUMX( FILTER( AD...
Is there any relationship between measure a, b and c. Just wondering if you could look at it from a maths point of view as to what needs to be true for all 3 to be greater than zero. That might be faster to test than actually evaluating the full values.
If you create a calculated table which materialises the table inside the sumx how many rows do you get? I agree with the others. Initial thought is it looks "ok". How slow is the query?
Only other thought is depending on what you need to slice by are you able to preagregate anything in a calculated table to move some evaluation away to model processing instead of live at query time.