Forum Discussion
Circular Relationship
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.
Greg_Deckler Hmmm how to explain ? Actually I have your book of expert in power bi modeling , what's section of calculation group , let me refer and see if I can implement the same
Anonymous Should just be something like:
CALCULATE(SELECTEDMEASURE(), USERELATIONSHIP('Table1'[Column1], 'Table2'[Column1]))Greg_Deckler ahhh got it
Greg_Deckler yes this is what I have tried
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.