Alternatives to virtual relationships

There are options to modify data models to support physical relationships and thus avoid the limitations with virtual relationships.

  • A concatenated column such as Year-Month could be created for each table via SQL, M, or a DAX calculated column.
  • Bridge tables with bidirectional cross filtering relationships provide simple solutions to many-to-many scenarios
  • For small fact tables (for example, Plan), LOOKUPVALUE() could be used in a calculated column supporting the relationship
上一章目录下一章