How to solve Inactive Relationship Problem with Role Playing Dimensions in Power BI

Role-Playing Dimension is one way of solving the inactive relationship problem in Power BI. Download the dataset for this example from my blog article here:

[JenMayB]

Thank you! Will a date slicer apply to all date dimension tables so that one date selected would update all visuals & measures?

[j_esc]

Something to note, in this example the Role Playing Dimension is connecting to the rest of the model with different columns from Order Date because Order Date is being used or 'filtered'. But if you create a Role Playing Dimension and you're wanting to create an active relationship with the SAME column then using ALL will result in a Many to Many relationship when you try to connect them. I think this is because the default behavior of ALL is to ignore filters on the table being referenced. Therefore, if you change the formula to Ship Date = 'Dimdate' with the table in single quotes, this essentially creates a 'real' new table rather than the 'copy' with no filters applied.

[mastankomatla]

where can i get series of your videos. Especially for Power BI DAX video series.

[gopigadde]

Hi @RADCAD, What if we use 2 fact tables and 2 Conformed dimensions rather than Role-playing Dimensions? What would be the approach to solve this in-active relationship in modeling?

[laviniaionescu]

Is there any difference in performance for creating the role playing dimension table between duplicating the table vs importing the table twice/creating the role playing dimension tables with DAX formulas?

[gangababupatchipala]

This video helped me a lot. Thank you!

[andylewis]

You are a God send sir!! Thank you so much

[saadhanif]

Can you please tell me how to the same trick is applied on Ms. Excel?

[dannygrovers]

what it happens if I want a relation to a big table, but it's is not a measure, it is a string column..

[Skoo]

You can't do this if your using and Oracle database with direc query

[ks.karthick]

It is Better to buy license for both Power BI Premium and Azure AS, May I know your idea on this?

[ks.karthick]

I need one clarification from you regarding Power BI Licensing with Azure AS

[azharshaik]

what incase if you have huge dataset ?