DAX Optimizations Examples with Alberto Ferrari

Join DAX Expert, Alberto Ferrari, as he answers the question how do you optimize a DAX expression? In this session, we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
As you will see, most optimizations are the direct application of best practices, but the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.
This video was recording during the Calgary Power Platform User Group on May 13, 2020.
Watch the April Meeting
• Power Platform User Gr...
Download the presentation and pbix file here:
bit.ly/3fRD3es
Join the Calgary Power Platform User Group Community site and never miss a meeting!
bit.ly/YYCPPUG
Alberto Ferrari Social Profiles
LinkedIn: / albertoferrarisqlb
Twitter: / ferrarialberto
www.sqlbi.com
----------------------------------------------------
Follow Iteration Insights! LinkedIn: / iter. .
Twitter: / iterinsights
Facebook: / iterationins. .
Instagram: / iterationin. .
www.iterationinsights.com
Music: www.bensound.com

[@po9mn]

The best SQLBI optimisation video I've seen. Thanks.

[@sanjeevsoni6793]

There are no words of Thanks. Excellent !!! Alberto

[@louism.4980]

Thank you so much, really enjoyed your video!

[@anujasule8077]

awesome ..thanks

[@deepakvermait-ho8081]

Superb. Thanks a lot Aberto for this nice video.

[@mikloshimics7789]

Brilliant!

[@porraloka31]

Using "values(Order[order date])" in the Amount(EUR) solves the problem and is more flexible since we have a more detailed granularity. I found using "calculatetable(orders, orders[order date]

[@diegoj9056]

Great video. What about using SUMX(orders,1) instead of Countrows or Distinc count?