User Relationship not working in Service

[Robert14358]

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.

[Robert14358]

so it doesnt work in direct query reports?

[tharunkumarRTK]

@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!