Forum Discussion

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 ...

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 )  
)

Community Champion

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 )  
)