Forum Discussion
Comparing Values from 2 Different Tables
Hi aashton
Related() function return single value from another table, it is better to use the function between the tables with relationship one-to-many, and use the related() function to the tables with table(many), you can refer to the following link.
Power BI RELATED | How to Use RELATED Function? (Examples) (wallstreetmojo.com)
The relationship between your tables is many to many, it contain to many values, so the related() fucniton cannot renturn the related single value, you need to simply your table relationship, you can creat a bridge table between two tables, you can refer to the following link.
Joining Many to Many with a Bridge in Power BI | Seer Interactive
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi aashton
Related() function return single value from another table, it is better to use the function between the tables with relationship one-to-many, and use the related() function to the tables with table(many), you can refer to the following link.
Power BI RELATED | How to Use RELATED Function? (Examples) (wallstreetmojo.com)
The relationship between your tables is many to many, it contain to many values, so the related() fucniton cannot renturn the related single value, you need to simply your table relationship, you can creat a bridge table between two tables, you can refer to the following link.
Joining Many to Many with a Bridge in Power BI | Seer Interactive
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.