Forum Discussion

Oliver_Buchanan's avatar
Oliver_Buchanan
Icon for Helper I rankHelper I
1 month 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
1 month 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
1 month 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
    1 month 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