Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified

Posted on April 29, 2019April 30, 2019 by Reza Rad

In the previous article, you learned the basics of relationships, you learned why we need a relationship, and what is the filtering impact of it across multiple tables. In this article, you will learn about one of the most important properties of a relationship called Cardinality. Understanding what the meaning is of 1-1, 1-Many, Many-1 Read more about Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified[…]

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

Posted on November 20, 2018 by Reza Rad

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 Read more about UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI[…]