RELATED DAX function with inactive relationships in Power BI

In this video we unravel the secrets of leveraging the RELATED DAX function with inactive relationships in Power BI. Relationships are the backbone of effective data modeling, offering a spectrum of types—from one to many, many to many, to one to one. Additionally, we have the flexibility to set cross-filter directions, be it single or both, active or inactive relations.

Sometimes we are in a situation where we cannot have an active relationship between two tables which is normal because we have a USERELATIONSHIP dax function to make inactive relationships active.

Building on this foundation, we'll also delve into the robust capabilities of the RELATED and RELATEDTABLE DAX functions. While there's a dedicated video on these functions (link provided below), our focus today is on uncovering the potential of the RELATED function in the context of inactive relationships. Expect a real-time example walkthrough to ensure a comprehensive understanding of the concept.

Enjoy and share, and leave your valuable and constructive feedback.

Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI -    / @powerbihowto  

Link to the RELATED and RELATEDTABLE video:    • Let's explore how I used RELATEDTABLE...  

🌏: https://perytus.com/
✍: https://perytus.com/blog/
📞: https://perytus.com/contact/

0:00 Intro
1:13 Problem Statement
3:28 Let's work on the solution
5:02 Set CROSSFILTER direction to both - is this a solution?
8:24 Another solution, let's how it goes?
11:10 Final solution
14:32 Summary and final thoughts

#powerbideveloper #businessintelligence #bi #perytus #decipheryourdata #powerbipro #powerbideveloper #dax #fieldparameters #calculationgroups #learnpowerbi #howtopowerbi #powerbitraining #powerbiforbeginners #dataanalysis #microsoftpowerbi #microsoftpowerbidataanalysis #visualinteraction #visualizaton #disconnectedtables #datamodeling #related #userelationship #inactiverelationship