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?
Can you please tell me how to the same trick is applied on Ms. Excel?
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?
This video helped me a lot. Thank you!
what it happens if I want a relation to a big table, but it's is not a measure, it is a string column..
You are a God send sir!! Thank you so much
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 can't do this if your using and Oracle database with direc query
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.
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
Thank you very much
A W E S O M E trick!!! Thx
Sorry but get to the point lol