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.
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?
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?
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
Thank you! Will a date slicer apply to all date dimension tables so that one date selected would update all visuals & measures?
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.
Thanks for the tip!
Thank you!
Awesome.Thank you for the tip
where can i get series of your videos. Especially for Power BI DAX video series.
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?
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?
Can you please tell me how to the same trick is applied on Ms. Excel?
what it happens if I want a relation to a big table, but it's is not a measure, it is a string column..
It is Better to buy license for both Power BI Premium and Azure AS, May I know your idea on this?
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
@@RADACAD Thank you for your immediate response.
I need one clarification from you regarding Power BI Licensing with Azure AS
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.
You are a God send sir!! Thank you so much
This video helped me a lot. Thank you!
You can't do this if your using and Oracle database with direc query
what incase if you have huge dataset ?
if your dimension table is big, then create an INACTIVE relationship and use the USERELATIONSHIP function method
@@RADACAD Thanks for the quick response
A W E S O M E trick!!! Thx
Thank you very much
Good one ! thanks
Sorry but get to the point lol