the column either doesn't exist or doesn't have a relationship....(Even when I have a relationship)

[wpf_]

I added a table called 'LeaveReasons' into the model manually by doing "enter data".  I created a relationship with  the 'Request' table.  I linked the table with the common fields.  But when I test in dax to create a new table I am getting msg: the column LeaveReason[category] either doesn't exist or doesn't have a relationship to any table available in the current context. 

This is the dax I have:

Table =

ADDCOLUMNS(

Request,

"reason", RELATED(LeaveReason[Reason])

"category", RELATED(LeaveReason[Category])

)

But it works when i just drag the tables into a table visual.  I want to do a left outter join with them in a variable, and i find it faster this way then to do a join in power query.  

[BA_Pete · Accepted solution]

Hi @wpf_ ,

I believe this is a bug, whereby RELATED() does not work between tables that are mixed Direct Query/Import.

You can check issue progress and vote here: https://community.powerbi.com/t5/Issues/DAX-function-quot-RELATED-quot-does-not-work-between-DirectQ...

Pete

[wpf_]

@BA_Pete thanks I think you are right.  

[VijayP]

@wpf_  Question is bit confusing. 

Have you created a manual table or created table with DAX? can you share the Model view to see what tables you are dealing with and where is the issue!?

[wpf_]

@VijayP ,

I cant really share the table because it is a directquery.

I created a table manually by going into "Enter Data".  Then i set the relationship in the model view.  Then to test it in dax, I tried that code in dax studio and in power bi desktop.  In power bi desktop i went to "New Table" and used that code.