Forum Discussion
Conditional Column from Multiple Tables
Thank you so much. Custom Column query is recognising only one table : TableDim1
Main Table:Table Dim1 Relationship *.1
Main Table:Table Dim2 Relationship 1.*
Main Table:Table Dim3 Relationship 1.*
Do you know why? I believe the error is because how relationship is set up.
It is most likely due to cross filter direction. The arrows need to point to your main table in all three relationships for this to work. Since your relationships are 1 to many and many to 1, this doesn't happen for all of them by default. You can change the cross-filter direction to both, just read up on that a bit as it may have some other impact on other data in your visualizations.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
Thank you Allison,
I appreciate if you mentioned that it is most likely due to cross filter direction. The arrows need to point to your main table in all three relationships for this to work. It was key factor and achieved desired results.