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 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 Yes I could lie to model and change the cross filter direction but still cant use the Inactive relationship. I have added another DIM table PRODUCT_INFO_DIM as below ,
and now I wana calculate Daily Complaints Qty as 1 DAX in such way that
1. It should follow DATE_DIM -> Daily Complaints join when I select any DATE_DIM field in Report or
2.It should follow PRODUCT_INFO_DIM -> Daily Complaints join when I select any PRODUCT_INFO_DIM field in Report
similarly i may have few more dimension tables to add here and the previously created DAX should work with new join between New Dim and Daily Complaints.
Please suggest
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])) )