Information extraction through bridge table

JuanTI_1798 — Fri, 20 Oct 2023 13:49:39 GMT

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

Re: Information extraction through bridge table

lbendlin — Sun, 22 Oct 2023 19:25:04 GMT

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

topic Re: Information extraction through bridge table in Developer

Information extraction through bridge table

Re: Information extraction through bridge table