Forum Discussion
Bridging Table not working as expected
I have two tables that I need to show data from. They both have a 'National Code' that is not unique in either table. I am trying to use a bridging table consisting of one column with a comprehensive list of unique 'National Code's. The visual (a Table) that contains info from both tables errors. Can anyone tell me what I am missing here? Here's screenshots of a moc example:
Hi Anonymous ,
It’s prompted that can’t display the data coz power bi can’t determine the relationship between these two tables.
Why don’t you try to set the relationship bwteen CourseMasterData with LearningBankData1 directly?
6 Replies
smpa01Community Champion
What is the measure you created that is generating the error. Can you please share the measure and the error it is generating- amitchandak
Super User
Select cmd_national_code from bridge table. and try.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin 
v-frfei-msftCommunity Support
Hi Anonymous ,
It’s prompted that can’t display the data coz power bi can’t determine the relationship between these two tables.
Why don’t you try to set the relationship bwteen CourseMasterData with LearningBankData1 directly?
