How to use 2 inactive relationships using USERELATIONS for slice and dicing?

[Anonymous]

Hi, can anybody tell me how to use 2 inactive relationships between tables for slicing and dicing?

I know we can use for USERELATION function in measures but when I use 2 USERELATIONS, it doesn't work anymore and causing ambiguity.

[amitchandak · Accepted solution]

@Anonymous , if you want to active two between 2 tables Say from A to B and C

new measures

Try like

calculate(count(TableA[col]), USERELATIONSHIP(A[ID], B[ID]) ,USERELATIONSHIP(A[SID], C[SID]))

Same two table

calculate(count(TableA[col]), USERELATIONSHIP(A[ID], B[ID]) )

+

calculate(count(TableA[col]), USERELATIONSHIP(A[SID], B[SID]) )

[Anonymous]

Thanks, I found out CROSSFILTER does the same work.