UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI

In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will explain two different methods that you can deal with this kind of relationship. So, ready? Let’s go through it.

If you want to learn more about Power BI, read Power BI book from Rookie to Rock Star.

Read rest of the blog post here: https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi