Supporting virtual table relationships
Virtual table relationships are DAX expressions to filter a table from another table when a relationship doesn't exist between these tables. Report visualizations can then be constructed using both tables (and their related tables) and the DAX measures will update as though a normal relationship is defined. Virtual relationships are often used to address disparate grains of tables and to leverage performance segmentation tables.
Although physical relationships are the preferred long term solution for both performance and manageability, virtual relationships provide an attractive alternative when physical relationships are not feasible. In this recipe we provide virtual relationship examples of using a custom performance segmentation table and an aggregated table.
How to do it...
Segmentation example
The goal of this example is to apply the following table to the measures of the data model:
Sales Growth Segmentation Table
A sample Power BI report based...
