What is role-playing dimension?

< 1 min read

A role-playing dimension is a single dimension table used multiple times for different business meanings.
In my sales model, one Date table was used as Order Date, Ship Date, and Delivery Date.
Instead of creating three physical tables, we reused the same Date dimension logically.
Only one relationship stayed active while others were inactive.
Measures used USERELATIONSHIP to switch between them when needed.
For example, revenue by order date vs revenue by delivery date.
This kept the model small and avoided duplicate data maintenance.
It also ensured consistent calendar hierarchy across all reports.
Very common in logistics and order lifecycle analysis dashboards.

Power BI Essentials