The Relationships View
The Relationships View provides the equivalent of a database diagram specific to the tables loaded to the model for the dataset. The relationship lines distinguish the one, or parent, table of each relationship from the many, or child, table. A solid line indicates that the relationship is active, while a dotted line denotes an inactive relationship that can only be activated via the USERELATIONSHIP() DAX expression. Additionally, the arrow icons on the relationship lines advise whether cross-filtering is single-directional (one arrow → one way) or bidirectional (two arrows).
In the following screenshot from the Relationships View, only the Reseller to Reseller Sales relationship is bidirectional and the relationships ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access