Forum Discussion

alsm's avatar
alsm
Icon for Helper III rankHelper III
2 years ago
Solved

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

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[...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    2 years ago

    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.

ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
2 years ago

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's avatar
    alsm
    Icon for Helper III rankHelper III
    2 years ago

    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