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.
Anonymous Pretty sure what you are after are Calculation Groups. Calculation groups in Analysis Services tabular models | Microsoft Learn
Greg_Deckler or may be I can use multiple userelationship in 1 DAX
Anonymous It's possible. Perhaps if you had a toggle like a disconnected table something like:
Column1
Option 1
Option 2
And perhaps a structure like this:
Sales = SWITCH( SELECTEDVALUE('Disconnected Table'[Column1], "Option 1", SUM('Sales'[Value]), CALCULATE( SUM('Sales'[Value]), USERELATIONSHIP('Table1'[Column], 'Table2'[Column])) )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.