Season 1

Namaste Power BI

Episode 9

Relationships & Filter Flow

⏱ 40:00

Episode Summary

How filters propagate through relationships in the data model — single vs bidirectional, active vs inactive relationships, and how CROSSFILTER changes flow direction in DAX.

This is Episode 9 of the free Namaste Power BI course on DevWithData — covering relationships & filter flow. Watch the video above, then pass the MCQ checkpoint to unlock the next episode and update your Data Readiness Index score.

Key Takeaways

→Filters flow from the "one" side to the "many" side by default
→Bidirectional filtering creates ambiguity and performance issues
→Only ONE active relationship can exist between two tables
→USERELATIONSHIP activates an inactive relationship in a measure

⚠ Common Interview Pitfalls

•Enabling bidirectional filtering on all relationships
•Having multiple active relationships between the same two tables
•Not understanding why your measure returns wrong results (filter flow!)

Official Reference

Deepen your understanding with official Microsoft documentation.

PL-300 Official Training Course

Microsoft's official instructor-led training for the Power BI Data Analyst certification.

https://learn.microsoft.com/en-us/training/courses/pl-300t00

Power BI Documentation

Complete reference for Power BI Desktop, Power BI Service, and Power BI Embedded.

https://learn.microsoft.com/en-us/power-bi/

Content on DevWithData is original and inspired by official Microsoft resources. The links above point directly to Microsoft Learn — always the authoritative source.

← Ep 8: Star Schema Mastery

Ep 10: Date Table & Time Intelligence →

Episode Checkpoint

Sign in to attempt the quiz and unlock the next episode.