Forum Discussion
Information extraction through bridge table
Good afternoon community,
I have the following question, following good practices, a bridge table was created to be able to join the GuiaDespacho and reng_fact tables through the mark table since if I directly joined the fact_num columns, it was a many-to-many cardinality. Now I want to consult the stock of the table reng_fact for each num_fact of the guiadespacho table
1 Reply
That's not a bridge table, it is a dimension table. (Nothing wrong with that, in fact it is better than a bridge table).
A bridge table allows the filters to progress to the other side. In your case the arrows are preventing that.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
