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.


rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.