Creating new column based on values from values from two other tables

[atpbi10]

I have three tables with this relationship:

 

I want to create a new column/measure that I can use to filter my visuals later, which basically takes two columns, one from `Main` table and one from `MappingUtil`. 

So basically I want to filter out rows where the corresponding columns from `Main` and `MappingUtil` are equal. I tried using this to create new column in `Sheet1` table:

CorrectFloor = 
IF (
    RELATED ('Main'[Assigned Floor]) = RELATED ( 'MappingUtil'[Floor] ),
    "Correct",
    "Incorrect"
)

However Im getting error:

The column 'Main[Assigned Floor]' either doesn't exist or doesn't have a relationship to any table available in the current context

But as you can see in the model above it they are both linked to `Sheet1` table. What am I doing wrong?

[Anonymous]

Hi @atpbi10 ,

Could you please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business after removing sensitive data?😀

Best Regards,
Eyelyn Qin

[lbendlin]

that is incorrect. You can influence the connection type and the search direction.  Also check your source data for irregularities (duplicates in columns where you expected unique values)

[lbendlin]

You may want to read up on some of the fundamentals of Power BI, especially the application of star schemas. Please rethink the relationships between your tables.

[atpbi10]

Hey thanks for the reply. I had no choice in how those relationships were applied, powerbi locked them in and does not allow to change.