Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Issue on Bridge Table Showing Duplicate Values

Hi,   I created a bridge table using clients    Upon creating a relationship, Power BI showed a company as duplicated and when I filter this client it seems like there is no duplication.   Any ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

The goals is establish a relationship between the two data sheets using the bridge because each sheets contain information that only exist on the other like the cost is on the other sheet while the responsible person is on the other.  btw these information were taken out from the data sheet to protect sensitive data.

 

The only unique identifier is the proposal number but even this one is being flag by power bi as duplicates as shown from the screenshots even after I had used the remove duplicates from the power query.

 

Hope someone can help me

 

 

 

mickey64's avatar
mickey64
Super User
2 years ago

There are many duplicate DATA in 'Append1' table.

I delete all duplicate rows and add a relationship between 'Append1' and 'Append_WIP'.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    are you able to share the pbix so i can understand what you had done