RELATED gives null value

[mansiluthra12]

Hi Everyone , 
I have two tables say - Work (id, testid, description) and Test(id,description). 
there is a relationship between work(testid and test (id). 
I am creating a query - = RELATED('test'[description]) in work but it gives blank values. 
Can someone help to sort , what's the issue ?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like, but please check whether your Test table has a unique ID column.

Check the below picture and the attached pbix file.

[mansiluthra12]

yes, I didn't had unique column for test id.

[Fowmy]

@mansiluthra12 

Not clear about the type of relationship and the tables, please refer to this article: 
https://radacad.com/get-a-field-value-from-a-related-table-in-power-bi-dax-related-function-explaine...