Performance of a DAX Formula

[luxpbi]

Hi, 

How can I measure the performance of a DAX measure and column? 
I've created a DAX column and it work perfectly but I think I've created a monster and now my PBIX works extremely slow.

Regards,

[v-piga-msft]

Hi @luxpbi,

Many factors may affect the performance of Power BI, such as large data size, data model and the complex dax expression.

I'm not clear what functions or formula do you use, but you could have a reference of the article below to optimize your performance in Power BI.

https://www.sqlbi.com/articles/optimizing-dax-expressions-involving-multiple-measures/

http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

Best  Regards,

Cherry

[luxpbi]

Hi, 

Thanks for your response, but what I'm looking for is a tool for testing different measures.
I've already seen the articles. 

Something like: 

What's the name of the tool?

Regards,

[v-piga-msft · Accepted solution]

Hi @luxpbi,

By my research, this tool should be Dax studio.

Reference:

https://www.sqlbi.com/blog/marco/2016/11/01/new-server-timings-features-in-dax-studio-2-5-0-dax-powe...

Best Regards,

Cherry