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:
radacad.com/userelationship-o...

[@gangababupatchipala3728]

This video helped me a lot. Thank you!

[@andylewis622]

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

[@raz8657]

Good one ! thanks

[@midsummer4864]

Thank you very much

[@JenMayB]

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

[@j_esc9]

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.

[@philippekinnaer1928]

Thanks for the tip!

[@ilhamrozie9951]

Thank you!

[@phanisudhabathula]

Awesome.Thank you for the tip

[@gopigadde6752]

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?

[@laviniaionescu8378]

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?

[@saadhanif4628]

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

[@mastankomatla4932]

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

[@dannygrovers3628]

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

[@BajkeTheSerb]

A W E S O M E trick!!! Thx

[@ks.karthick3356]

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

[@RADACAD]

when using Azure AS with Power BI; you would need to pay for those licenses separately. I have done another video on Power BI licensing too.

[@Skoo84]

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

[@ks.karthick3356]

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

[@RADACAD]

If you buy Premium, you get dedicated capacity anyways, so you won't need to buy Azure AS. But in details have to check the requirement. Behind the scene both services are one

[@ks.karthick3356]

@@RADACAD Thank you for your immediate response.

[@azharshaik21]

what incase if you have huge dataset ?

[@RADACAD]

if your dimension table is big, then create an INACTIVE relationship and use the USERELATIONSHIP function method

[@azharshaik21]

@@RADACAD Thanks for the quick response

[@zzzzzzzzzzzzzzzz9]

Sorry but get to the point lol