Forum Discussion
RELATED gives null value
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 ?
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.
3 Replies
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-explainedHi,
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.
yes, I didn't had unique column for test id.
