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

Hi,

 

I changed the filter from both to single for both one-to-many and many-to-ne but still have the same issue as shown

 

 

 

 

 

 

mickey64's avatar
mickey64
Super User
2 years ago

I got your DATA.

I think there are many mistakes. (^^;

 

Step 1: There are many dupulicate DATA in 'Append_PNS_Sheet'.

    I delete these duplicate rows.

 

Step 2: I make a PBIX-file and add a relationship between 'Proposal No' and 'Proposal'.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks Mickey. Those Unspecified rows are previously blanks and I want them because there are proposal that were created even without clients. Are you able to help address this issue?

    • mickey64's avatar
      mickey64
      Super User
      2 years ago

      If you can provide me with a goal image, I think I can 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