Facing issue while working with Bridge Table in Power BI

I replicated the issue you are having with some dummy rows as you can see below:

Also, see below the error I receive when:

• Project Code ("Bridge") is "Dont Summarize"
• Sales (Table 1) is "Dont Summarize"
• Budget Sale (Table 2) is "Dont Summarize"

I believe this error makes sense. When you select fields from Table 1and Table 2 to “Don’t Summarize,” Power BI tries to display row-level data from two tables that are only indirectly related via the "bridge".

Without a direct row-level relationship between Table 1 and Table 2 tables, there is ambiguity in matching the data, which results in the error.

To resolve this, either use aggregated measures (so that multiple rows are combined into a single value per project code):

Or what I think you will need to do in your case is adjust your data model by merging the tables since row-level detail is essential for you and all the columns you need are descriptive and should not be aggregated.

Updated: You may notice i use bridge in "" above - this is for two reasons. One we should not really be using fields from the bridge in our visuals. They should simply be there to support the propogion from one table to another. Also, both are single direction, in reality in a star schema model one should be both diectional. Hope this helps.