Role-playing dimensions present some interesting challenges for modeling & reporting in Power BI (and SSAS Tabular for that matter), but also some opportunities to think outside the box and create more intuitive solutions. What are role-playing dimensions? In technical terms a role-playing dimension is when a dimension table has multiple (foreign key) relationships to the …
