Role-playing dimensions allow a single dimension table to serve multiple roles in a data model, avoiding data duplication. Using Power BI and DAX, you can combine identical dimension tables (e.g., salespersons and managers) into one generic 'employee' dimension using Power Query's append feature. Multiple relationships are created between the dimension and fact table — one active and the rest inactive. The USERELATIONSHIP DAX function lets you explicitly activate an inactive relationship in a measure, enabling side-by-side analysis of the same entity from different perspectives. This approach creates a single source of truth, enforces standards, and scales easily when new roles are added.
•15m watch time
25 Impressions