Bridging Table not working as expected

[Anonymous]

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:

[v-frfei-msft · Accepted solution]

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?

[Anonymous]

Thanks Frank,

Yes this works thanks. I was using an older version of PBI which did not have the many to many cardinality. I have now got the new version and the many to many works just fine. Thanks

[amitchandak]

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

[Anonymous]

No that did not work. Here's a link to the file.

https://www.dropbox.com/s/l75tln43a96rl9s/BridgingTable.pbix?dl=0

[smpa01]

What is the measure you created that is generating the error. Can you please share the measure and the error it is generating

[Anonymous]

I am not using any measure, just the 'CMD_National Title' from the 'CourseMasterData' and the 'LB_Info'from the 'LearningBankData1' as per the screen shot. The error is shown in the screen shot also.