Forum Discussion

Robert14358's avatar
Robert14358
Icon for Resolver III rankResolver III
1 year ago

User Relationship not working in Service

Im not sure what is going on here

 

these measures are working in desktop but not the service, it is a composite model with direct query/mport and both measures use the "USERELATIONSHIP" function.

 

 

Need Help

2 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Icon for Super User rankSuper User
    1 year ago

    Robert14358 

    Are you aware of all the limitations of using USERELATIONSHIP() function?

    for example if your model has RLS implemented then USERELATIONSHIP() wont work, similarly there are few other limitations, you can read them here

    https://dax.guide/userelationship/

    In such scenarios consider using TREATS() function to create a virtual relationship 

    https://dax.guide/treatas/

     

    Need a Power BI Consultation? Hire me on Upwork

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!