Bridge Table Issues with blank rows

[donnie17]

Hi everyone,

I'm currently working on the budget analysis for our department, specifically comparing Forecast data with the Budget.

The Budget data is sourced from SAP, while the Forecast is manually compiled through a SAP extraction (of the Budget) and added as a new column.

To avoid many-to-many relationships, I’ve created a Bridge Table that includes the common fields between Budget and Forecast, along with a key column. This allows me to establish a one-to-many relationship between each Fact Table and the Bridge Table.

In the report view, I’ve built a table visual using fields from the Bridge Table. The values come from Budget (e.g., budget, ordered, and invoiced) and from the Forecast table (forecast values).

However, I’m encountering an issue: the top row of the table shows blank fields along with some numeric data.
It seems something isn’t working as expected, but I haven’t been able to pinpoint the root cause.

Any insights would be greatly appreciated!

Thanks in advance for your support,

-D

[v-priyankata]

Hi @donnie17 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @donnie17 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted  If yes, marking the relevant solution would be awesome for others who might run into the same thing.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[v-priyankata · Accepted solution]

Hi @donnie17 

Thank you for reaching out to the Microsoft Fabric Forum Community.
@rajendraongole1 Thanks for your inputs.

Some rows in the Bridge Table don’t have any matching data in either the Budget or Forecast tables. But Power BI still shows those rows from the Bridge Table, which leads to blank or numeric values.

To avoid this, make sure the relationships From Bridge to Budget & Bridge to Forecast are both one to many and single directional.

Then use a DAX measure to filter out unmatched rows.

IncludeRow =
IF (
   NOT ISEMPTY(RELATEDTABLE(Budget))
   || NOT ISEMPTY(RELATEDTABLE(Forecast)),
   1,
   0
)

Go to table visual > filters pane > drag the Dax > set the filter is 1.

Thanks.

[v-priyankata]

Hi @donnie17 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[rajendraongole1]

Hi @donnie17  - Add the key column from the Bridge Table to the visual.

you can create a measure for unmatched rows using flag we can filter.filter your table with this measure to see where the join is failing.

Unmatched Budget Records =
IF (
ISBLANK( RELATED( 'Bridge Table'[Key] ) ),
1,
0
)

Hope this works. please check and let know.