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

     

     

     

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