Forum Discussion
Issues with Filtering Tables in Power BI After Manual Relationship Setup
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.
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.
2 Replies
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.
