Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
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