Related Function Not Working

[Anonymous]

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) side .

As soon as i use Realated fucntion to call column from Custom_Tab_schedule i am getting this error that i dont have any realtionship between any of these.

(i need column not measure )

Please see below screesnhot :

Request to please help on this.

Thanks,

Ash


@Ashish_Mathur 
@amitchandak 

[suparnababu8]

Hi @Anonymous 

1. If you are yousing mixed storage mode (one table - import mode and another table - direct query mode) RELATED function will not work properly. make sure that you have same storage mode for both tables.
2. Again if you want solution with different storage methods,  you can use LOOKUPVALUE function, this fuction may work better for mixed storage sceniories.
3. Make sure that, there are no blank or null values in the Process Name column on the one side (Custom_Tab_Schedule). Even a single blank value can cause issues with the relationship.

Additionally if you need more info you refer to following acctepted solutions.

Solved: RELATED function not working - Microsoft Fabric Community

Solved: RELATED Function with a Direct Query Table - Microsoft Fabric Community

Thanks!

[ToddChitt]

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?

[ToddChitt]

You definitely have a mix of Direct Query ( BPASession ) and Import ( CustomTab_Schedule ) tables in that relationship and that is the issue.