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 - youtube.com/@PowerBIHowTo
Link to the RELATED and RELATEDTABLE video: youtu.be/AOWbieiqVQ0
🌏: perytus.com/
✍: perytus.com/blog/
📞: 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
- RELATED DAX function with inactive relationships in Power BI ( Download)
- Using RELATED and RELATEDTABLE in DAX ( Download)
- Using USERELATIONSHIP to Activate Inactive Relationships ( Download)
- Power BI inactive relationships with CALCULATE & USERELATIONSHIP ( Download)
- USERELATIONSHIP Function in DAX ( Download)
- Changing inactive relationship to active relationship using DAX in Power BI ( Download)
- Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function ( Download)
- How to solve Inactive Relationship Problem with Role Playing Dimensions in Power BI ( Download)
- DAX Fridays #212: Using inactive relationships in slicers | USERELATIONSHIP ( Download)
- Active vs Inactive Relationship in Power BI | PowerBI Desktop | #powerbi #daxfunctions ( Download)
- Power BI Using Inactive Relationships | Userelationship in PBI | Two Join Conditions between tables ( Download)
- Using USERELATIONSHIP in DAX ( Download)
- How to Use Inactive Relationship In Power BI using DAX- USERELATIONSHIP - Interview Question PowerbI ( Download)
- DAX Fridays! #21: USERELATIONSHIP ( Download)
- 6 - Intro to DAX: Use the inactive relationship with CALCULATE and USERELATIONSHIP ( Download)
