Many-to-many Relationships in DAX

Let Alberto Ferrari show you how to work with many-to-many relationships in DAX by using an example from a banking data model. Unfortunately, these types of relationship do not just work out-of-the-box—you need to apply correct DAX formulas to benefit from their power, because of the way DAX handles filter context propagation over relationships. This fact lead some people to believe that DAX cannot handle many-to-many relationships! Fortunately, the opposite is true: you can work with any model with many-to-many relationships by following Alberto’s suggestions shown in this short, 3-minute video.

Watch video


Enclose code in comments with <PRE></PRE> to preserve indentation.