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 

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

    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.