Forum Discussion

juan_pablo's avatar
juan_pablo
Icon for Helper V rankHelper V
4 years ago
Solved

USERELATIONSHIP doesn't deactivate the active relationship

Hi, When I use the DAX function USERELATIONSHIPS it doesn't acts as the documentation says and it keeps using the active relationship instead of the indicated by the function.   I made this simple...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Time to update the documentation, I guess.  I see that it can be misinterpreted.

     

    What you _can_  (probably) do is make the connection between Parciales and Documents inactive as well by default. That would then allow you to switch on either of them (but not both)

     

    Or you could consider merging the tables 13 and Parciales.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

That's not how this works. USERELATIONSHIP cannot be abused to try and trick the data model into accepting ambiguous connections between tables (multi path).  USERELATIONSHIP is used in cases where you have multiple connections between two tables (one active, and the rest inactive).  For example when you want to report on Order placement data, Order Ship data, and Order Delivery date  out of the same Order fact table.

 

Reconsider your data model.

  • juan_pablo's avatar
    juan_pablo
    Icon for Helper V rankHelper V
    4 years ago

    Hi lbendlin , the documentation says:
    "[...] it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments."

     

    The model includes all tables, all relationships, I can't see anything in the documentation (nor DAX Guide from SQLBI) restricting to relationships between only two tables. Also, if the function "overrides any other active relationship" so there would not be ambiguous paths, so it won't be tricking the model.