Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

USERELATIONSHIP not working

I have a table NU with the below data :   AC No        SA   LC 156657 898 a 156657 -90 b 877879 213 c 877879 242 d   34 e   Table RR with the below data :   Cust   ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Some times you need to CROSSFILTER the other relationship to None

     

    FA cus = 
CALCULATE (
    SUM ( 'RR'[FA] ),
    USERELATIONSHIP ('RR'[Cust], 'NU'[AC No] ),
    CROSSFILTER ( 'RR'[LC], NU[LC], NONE )  
)

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj