Forum Discussion
Related Function Not Working
Hi There, I am trying to call one column (Process NAME) which is placed in Custom_Tab Schedule Table 1-Many realtionship with BPASession table . They both are joined on Process Name (Many To 1)...
Your picture of the measure definiton lists the "Cross filter direction" as Single, but the screenshot of the two tables indicates that it is Both. There is something night right there.
Also, if this is the column that is involved in the relationship, any rows WILL BE EQUAL to the value in the other table, so why are you trying to get that same value from another table?
Also, is one table Direct Query and one Import? That might be your issue. Is that why you have the extra "( )" icon shown in the relationship line between the two tables?
You definitely have a mix of Direct Query ( BPASession ) and Import ( CustomTab_Schedule ) tables in that relationship and that is the issue.