Dax using USERELATIONSHIP not working in power bi Service

[bharatis]

Hi ALL,

I have created a dax using USERELATONSHIP as I have inactive relationship with dimension table Company:

calculate(SUM(PL[AMT_0]),USERELATIONSHIP('LIVE COMPANY'[CPY_0],'PL'[CPY_0])).

This is working fine in my power bi Desktop but not on power bi Service with error :

Please help!

Regards 

Bharati

[lbendlin]

What makes you think that USERELATIONSHIP is causing the error?

[bharatis]

Hi ,

When i remove the USERELATIONSHIP it works fine. I changed the syntax to 

TREATAS and this is working fine. Thanks for replying though.