--- title: "Power BI Role-Playing Dimension (USERELATIONSHIP) | #Power BI Course 22" url: https://daily.dev/posts/power-bi-role-playing-dimension-userelationship-power-bi-course-22-ywggjddyt source_url: https://www.youtube.com/watch?v=FbMVYHYM-oE type: video:youtube source: "Data with Baraa" published: 2026-06-11T13:01:35.842Z updated: 2026-06-11T13:02:58.101Z tags: ["power-bi"] reading_time: 15 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Power BI Role-Playing Dimension (USERELATIONSHIP) | #Power BI Course 22 **[Data with Baraa](https://daily.dev/sources/datawithbaraa)** · 15 min read · 0 upvotes · 0 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#power-bi](https://daily.dev/tags/power-bi) [View this post on daily.dev](https://daily.dev/posts/power-bi-role-playing-dimension-userelationship-power-bi-course-22-ywggjddyt)