By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-crossfilter-function/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This video explains how relationships in a data model affect filters in visuals and DAX measures. You'll learn how to use the CrossFilter function in DAX to control how filters propagate and return the correct results regardless of the cross filter direction setting in the relationship. You'll also see how to sync slicers without needing to enable bi-directional filters on every relationship in a model.

Chapters
00:00 Topic list
00:42 Setting Up the Basic Report
01:57 Relationships and Cross Filter Direction
04:46 How Filter Direction Affects Measures
08:03 Specifying Filter Direction in a Measure
10:51 Getting a List of Filtered Values
13:10 Dealing with Multiple Relationships
17:33 Restricting the Filter Direction
22:21 Synchronising Slicers using Measures

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!