multiple slicers with unique values from multiple tables showing as inactive relationship

[alsm]

I have created multiple calcualted tables with unique values from different tables as follows:

DistinctCcy = FILTER(DISTINCT(UNION(VALUES(RT_A[CCY]),VALUES(RT_B[Currency]), VALUES(RT_TRC_RATIOS[Currency]))), [CCY] <> BLANK())

DistinctLocation = FILTER(DISTINCT(UNION(VALUES(RT_A[Location]),VALUES(RT_B[Location]), VALUES(RT_C[Location]), VALUES(RT_C[Location]), VALUES(RT_TRC_RATIOS[Location]))), [Location] <> BLANK())

etc.

when I link these calculated tables to the table 'some' of the links are inactive links and hence cannot be used a slicer. why are some of these inactive link. What am I doing wrong? How to make them active so that they are applicable to all charts

[ALLUREAN · Accepted solution]

Hi, 

Would you show the whole picture of your data model. Most probably there is relationship with filter direction set as Both that can cause ambiguity.

[alsm]

Thank you for the hint @ALLUREAN , I deleted the connections and created one-by-one all. This helped me locate the problem relationship. Now all relationships are active