Issues with Filtering Tables in Power BI After Manual Relationship Setup

[jzhao]

I'm facing a strange issue. I loaded data using a direct query with an imported relationship, and I can filter the table using the following code:

Filter(Direct Query Imported Relationship Table, related(lookup table[fiscal year]) > 2024).

However, when I set up the relationship manually, I can no longer filter the table with this code:

Filter(Manually Set Up Relationship Table, related(lookup table[fiscal year]) > 2024).

Power BI throws an error saying, "Column doesn't exist or doesn't have a relationship to any table available in the current context." Does anyone know why this is happening?

All Relationship are many to one, cross filter direction is single.

[Anonymous · Accepted solution]

Hi @jzhao ,

As BeaBF  mentioned, check the model relationships between your tables.

You will get the error for the relationship shown below.

You need to change your model relationships to output properly with lookup table as one end table, see 

Using RELATED and RELATEDTABLE in DAX - SQLBI

Get a field value from a related table in Power BI: DAX RELATED Function Explained - RADACAD

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[BeaBF]

@jzhao Hi, can you paste the screen of the relationship? 

BBF