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.
Thsi is possibile only if we know what column we are would select in report visual like
'Disconnected Table'[Column1]
but we use any column from disconnected table and hence cant use Switch for so many columns
Anonymous Not sure I am following you. The disconnected table is simply there to allow you to switch between which calculation you want the measure to return. So there would only be 1 column and 2 rows in theory. Again though, Calculation Groups were designed for this situation specifically.
Greg_Deckler ahhh got it
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 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.