Forum Discussion

Oliver_Buchanan's avatar
Oliver_Buchanan
Icon for Helper I rankHelper I
25 days ago

USERELATIONSHIP Issue

Hello,  I'm having an issue diagnosing where the issues lies for this. But essentially my measures using USERELATIONSHIP aren't giving the correct values. Take these two measures CollectionAct...
Need Help
power bi
Oliver_Buchanan's avatar
Oliver_Buchanan
Icon for Helper I rankHelper I
25 days ago

I'm almost certain this is a microsoft bug. The joins succeed everywhere but the DAX measure itself

  • krishnakanth240's avatar
    krishnakanth240
    Icon for Super User rankSuper User
    25 days ago

    Hi Oliver_Buchanan​ 

    Most common cause is that USERELATIONSHIP requires relationship where it activates to the already existing inactive relationship in the model. If there is no inactive relationship defined between Action[CollectionActionEventKey] and ActionEvent[ActionEventKey] then USERELATIONSHIP will fail to apply and calculation falls back to what the active relationship path is

    Ensure you have the inactive relationship exists in model view with dotted line between exactly those two columns in the correct direction with one side single and many side on ActionEvent. If it does not exist then USERELATIONSHIP will not work

    Also check for ambiguous or multiple relationship paths. If there is more than one relationship path between Action and ActionEvent even indirectly through other tables then USERELATIONSHIP can behave differently 

    If CollectionActionEventKey and ActionEventKey are different data types like one is text and other one is whole number DAX relationship can fail to filter correctly 

    • Oliver_Buchanan's avatar
      Oliver_Buchanan
      Icon for Helper I rankHelper I
      25 days ago

      Yes i have the inactive relationship defined.
      There is no intermediary tables between Action and Actionevent there is 1 active relationship and then about a dozen inactive relationships.

      both types are whole numbers 64 bit integers