Forum Discussion

donnie17's avatar
donnie17
Regular Visitor
1 year ago
Solved

Bridge Table Issues with blank rows

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 manual...
Need Help
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    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's avatar
v-priyankata
Community Support
1 year ago

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.