Summary
Enable support for calculated tables in Direct Lake semantic models that reference Direct Lake tables, specifically to allow creation of role-playing dimensions (e.g., duplicating a Date dimension).
Problem Statement
In Direct Lake models, calculated tables that reference Direct Lake tables are currently not supported. This prevents modelers from creating role-playing dimensions (such as Order Date, Ship Date, Invoice Date) using simple DAX patterns like:
Ship Date = 'Date'
As a result, users must either:
Use inactive relationships with USERELATIONSHIP() (which increases measure complexity), or
Create duplicate physical dimension tables upstream in the Lakehouse/Warehouse (which adds data duplication and engineering overhead), or
Convert to composite models (which defeats the simplicity of Direct Lake).
on:
Customers should ereceive notifications for all th...
miguel
on:
Recent Data and Recent Connections
on:
Need more details on Average utilization% in Capac...
lbendlin
on:
Increase the 1,000 Item Limit per Fabric Workspace
NaamaTsafrir
on:
Rename "Domain Admin" to "Domain Owner" to match P...