Bridge Table Issues with blank rows

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.