Forum Discussion

Oliver_Buchanan's avatar
Oliver_Buchanan
Icon for Helper I rankHelper I
27 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
Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
27 days ago

Hi Oliver_Buchanan​ ,

  1. Check cross filter direction of 'Action'[CollectionActionEventKey] and 'ActionEvent'[ActionEventKey]
  2. If its not possible to change it permanently, then change cross filter direction using below  DAX example.
CollectionActionEventTimeuse =
CALCULATE (
    MAX ( 'ActionEvent'[Created] ),
    CROSSFILTER ( 'Action'[CollectionActionEventKey], 'ActionEvent'[ActionEventKey], BOTH )
)

I have given example of both cross filter direction you can change and try accordingly.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful