Cardinality and Cross filter direction
In this tutorial, you will learn about managing relationships, when you create or edit a relationship. In which case you can configure additional options like Cardinality and cross filter directions.
Cardinality
The Cardinality option has the following settings –
| Relationship | Purpose |
| Many to one (*:1) | It is one of the most common default types of relationship. It indicates that the column in a given table can have more than one instance of a value, and the other related table, know as the lookup table, has only one instance of a value. |
| One to one (1:1) | In a one-to-one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value. |
| One to many (1:*) | In a one-to-many relationship, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value. |
| Many to many (*:*) | Using composite models, you can build a many-to-many relationship between tables, which eliminates the requirements for unique values in tables. It also removes previous workarounds, like introducing new tables only to establish relationships. |
Cross Filter Direction
Cross filter direction has one the given settings,
Both: For filtering purposes, both tables are treated as if they’re a single table. The setting works well with a single table that has a number of lookup tables that surround it. In general, this configuration is known as a star schema configuration (a central table with several lookup tables). However, if you have two or more tables that also have lookup tables (with some in common) then you wouldn’t want to use the Both setting.
Single: In general, default direction, which indicates filtering choices in connected tables work on the table where values are being aggregated. Once you import a Power Pivot in Excel 2013 or earlier data model, all relationships will have a single direction.
