Forum Discussion

JM_nxgn's avatar
JM_nxgn
Helper I
7 years ago

Table Relations Ambiguity

Hello, I've recreated the scenario that I'm currently experiencing, hopefully someone can give me some ideas on how I can fix this issue.

 

I have two fact tables which share many dimension tables, for simplicity sake I've only picked a few columns and a few dimensions to work with. The relationship view can be seen below:

 

So i have picked the relations to be both directions, because I'm using report level filtering and need the filters to behave accordingly.

My current predicament is that it is forcing me to set the relationship between 'ReturnedGoods'[ProductId] and 'Dim_Product'[ProductId] to inactive, whereas I need it to be active. 

I have read up on the relationships and what's causing this. I sort of understand the issue, just not sure how I can get around it.

 

Thanks in advance.

 

 

Need Help

4 Replies

  • Geradav's avatar
    Geradav
    Responsive Resident
    7 years ago

    Hi JM_nxgn 

     

    Not sure to understand what is the problem you are seeking assistance with. Is it with the right DAX statement to create a measure or calculated column?

    You have mentioned that you have purposedly created a bi-directional cross-filtering relationship (being aware of the consequences I guess) and that you are aware of the USERELATIONSHIP() function. But, what are you trying to achieve exactly?

     

    Regards

    David

    • JM_nxgn's avatar
      JM_nxgn
      Helper I
      7 years ago

      Hello Geradav 

       

      So i'm actually not sure what the consequences of having the relationship being inactive is, but I assume it will be affecting the filtering. 

      I'm actually not sure of the use of the USERRELATIONSHIP() function or if it pertains to my issue at all. 

      Basically I have filters such as Product and Client (which I use from the Dim tables). 

      I have visuals within each page that contains information about the SoldGoods and ReturnedGoods. I just want to ensure that when I filter the items in the Dim_Tables, that it will filter accordingly on the entire report and consequentially on all visuals. 

      I assume if the relationship is 'inactive' as in the case mentioned above, the filtering will not work correctly. Am I wrong in saying that?