Forum Discussion
Circular Relationship
Hi All, I have below structure in my Power BI Model Now I want to use inactive join used between Date Dim and Daily Complaints without it going through active joins. Userelationship cant be ...
Anonymous If you want to change the Cross Filter Direction of any relationship, just lie to your data model and tell it that the relationship is 1 to many or many to 1.
Anonymous Should just be something like:
CALCULATE(SELECTEDMEASURE(), USERELATIONSHIP('Table1'[Column1], 'Table2'[Column1]))Greg_Deckler yes this is what I have tried
Greg_Deckler ahhh got it
Greg_Deckler would this work in report which is connected to live to Power Bi dataset based on direct query
Anonymous As long as it is in a measure and not a calculated column it should work. Also, you need to make sure that the tables do not have any RLS defined.
Greg_Deckler whats RLS defined table?
Anonymous Row Level Security (RLS) USERELATIONSHIP will not work on relationships where either table involved has RLS rules defined.