Mastering DAX + Optimizing in Toronto - Sept 19-23, 2016   Mastering DAX Video Course

Physical and Virtual Relationships in DAX

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalent filters using specific DAX patterns. This article show a more efficient technique to apply virtual relationships in DAX expressions.

Optimizing DAX expressions involving multiple measures

Measures summed

Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter arguments, and how to improve efficiency of your DAX code.


More articles



» ALL ARTICLES

Videos



» ALL VIDEOS

Connect with us







Next public conference

No upcoming events at the moment.
» ALL CONFERENCES