Forum Discussion

twister8889's avatar
twister8889
Icon for Helper V rankHelper V
5 years ago

DAX Improve performance - Starting

Hi guys,   I have a measure that is very slow, this measure depends on the other 24 measures, so I'm testing the performance (DAX Studio) one by one.   The measure is  Measure1 = STDEVX.P(TABLE1...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Good that you use DAX Studio.  Watch a few of their videos where they walk through the important pieces of query optimization.  Look out for the number of query steps, and the number of records that are consumed in each of the loops.  That will give you an idea where you can avoid unnecessary iterations.