Forum Discussion
Optimizing DAX performance
Hi All, I have a DAX measure that is taking too long for calculations. I was hoping if some one could help me optimize the code. Sample code: Measure = Var var1 = some calculation Var var...
So I was able to shorten thi block using SUMX(VALUES(Filter condition column), SUM()) and it worked.
Thanks for the help.
MariuszI already used dax studio and found out that this particular code is taking too long to execute. Everything else is fine. So thought of asking if there is a way I can restructure my code to make it more effectie.
Yeah, there is a way, albeit quite involved.
The first thing to do is to... learn how to structure models correctly so that DAX is speedy.
The second thing to do is to learn how SWITCH/IF is calculated.
And the best thing to do is to take the book "The Definitive Guide to DAX" and read it in full. Especially the part that deals with optimization.
Best
D
The first thing to do is to... learn how to structure models correctly so that DAX is speedy.
The second thing to do is to learn how SWITCH/IF is calculated.
And the best thing to do is to take the book "The Definitive Guide to DAX" and read it in full. Especially the part that deals with optimization.
Best
D
- One more thing... Without knowing what the model looks like and what the measure should do there is no way one could effectively optimize this measure.
Best
D