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 spend several days trying to get one-to-many or vice versa for my files but still being forced to many-to-many even after removing duplicates, replacing null/blank & done upper case then trim plus clean as shown

 

Here is the link of the pbix - https://file.io/MZybpJnT8UuO

 

I hope someone can assist me...

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It seems like the original link for the pbix is not working so here is the new one - https://file.io/EQWSdAo6TO03

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    Can you change ’Cross-filter direction’？

        Cross-filter direction: ’Both’--->’Single’’

     

    • 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'.