topic Issues with Filtering Tables in Power BI After Manual Relationship Setup in DAX Commands and Tips

Issues with Filtering Tables in Power BI After Manual Relationship Setup

jzhao — Tue, 15 Oct 2024 07:57:39 GMT

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.

Re: Issues with Filtering Tables in Power BI After Manual Relationship Setup

BeaBF — Tue, 15 Oct 2024 07:52:29 GMT

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

BBF

Re: Issues with Filtering Tables in Power BI After Manual Relationship Setup

Anonymous — Wed, 16 Oct 2024 06:10:47 GMT

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

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.