Forum Discussion
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 idea how I can get this issue sorted out
//NT
I'm a super user of Power BI Desktop but a beginner of this website.((+_+))
Can you download my files?
13 Replies
When I add a relationship with a key column that contains null data, I get the same error.
To solve it I replace the 'null's with text data such as 'No data'.Hi Anonymous
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
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...
It seems like the original link for the pbix is not working so here is the new one - https://file.io/EQWSdAo6TO03
Can you change ’Cross-filter direction’？
Cross-filter direction: ’Both’--->’Single’’
