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:
RELATED ('Main'[Assigned Floor]) = RELATED ( 'MappingUtil'[Floor] ),
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?
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
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)
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.
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.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.