Forum Discussion
DAX Studio issues and questions (Query Batch Completed with errors)
- 7 years ago
Anonymous wrote:Is DAX Studio capable of suggesting better/optimised DAX code?
No, at the moment we just provide an easier way to access a deeper level of information about the execution of a given query (such as the details around the Storage Engine queries) and access to Query Plans. It would be nice to add the ability for DAX Studio to suggest improvements, but it's a very difficult problem to solve well.
Hi d_gosbell
Thanks for your answer.
In that case, how shold I evaluate a measure or a calculated column performance?
It is not returning a table but a value of some kind.
Any advise on that area?
Cheers!
A
Anonymous wrote:In that case, how shold I evaluate a measure or a calculated column performance?
Calculated columns are calculated at processing time, not at query time. So they would impact on data refresh performance, but not on the performance of your report.
But you could do something like :
EVALUATE ADDCOLUMNS( table, "myCalc", <your calc column expression goes here> )
And compare that to the performance of a query without the column
eg.
EVALUATE table
For measures the simplest thing you could do is something like the following using the curly braces to generate an inline table
EVALUATE { [MeasureName] }That will run your measure, but only evaluates a single cell. It's probably more realistice to capture the queries from Power BI Desktop and run those in DAX Studio (the youtube video link I posted shows how to do this)
- Anonymous7 years agoNot applicable
Hey d_gosbell
Thanks for the tips.
I will play with it a little bit today and see how it goes.
Any knowledge about optimisation? Is DAX Studio capable of suggesting better/optimised DAX code?
Cheers!
A- d_gosbell7 years ago
Super User
Anonymous wrote:Is DAX Studio capable of suggesting better/optimised DAX code?
No, at the moment we just provide an easier way to access a deeper level of information about the execution of a given query (such as the details around the Storage Engine queries) and access to Query Plans. It would be nice to add the ability for DAX Studio to suggest improvements, but it's a very difficult problem to solve well.