Our data model comprises well-defined physical relationships between the tables, generating a star schema. However, there is another type of relationship we can create, and that’s a “virtual” relationship. A virtual relationship is a DAX expression that simulates the behavior of a physical relationship defined in the data model. In this chapter, you will learn to create virtual relationships that can resolve problems created by anomalies in the data model. Such ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_1717. Virtual Relationships: The LOOKUPVALUE and TREATAS Functions
Alison Box1
(1)
Billingshurst, West Sussex, UK
Get Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
