Duplicate values showing when they're not supposed to - separate vendors

[heathernicole]

Here is the data:

There are two POs with the same number, but two different Vendors. 

Each vendor has one design number:

Vendor 1 - Design # 213734

Vendor 2 - Design # 234407

That's how the data is listed within the database. However, in this particular matrix - it shows both designs for both vendors - which in theory, doesn't seem possible even though the PO number is the same. 

Any ideas of what might be going on here?

Thanks in advance!

DB View: Items in blue are what's relevant - no measures in this one. 

[v-huizhn-msft]

Hi @heathernicole,

In your first screenshot, besides [Due Date], [PO#] and [Design #], the [Vendor Name] is the same? From the name length, they are different. What's your requirement, you just want to 244793 once rathen than twice like the table shows, right? Could you please share more details for further analysis?

Best Regards,
Angelia

[heathernicole]

@v-huizhn-msft - I only want the design number to display with it's corresponding PO #.

Technically it shouldn't display that way. But I just did some research - the data is corrupt on the back end. The issue is actually not in the visual. 

It's a QuickBooks - sybase database I'm working with. I was able to look at some of the raw data and find the issues. 

So I don't think or know if this can actually be addressed; it's not a relationship issue as I first thought. It's displaying that way because that's how it really is. 😞 

[v-huizhn-msft]

Hi @heathernicole,

You mean the data stored in sybase database and displyed in Power Bi desktop are different?

Best Regards,
Angelia

[heathernicole · Accepted solution]

Hey @v-huizhn-msft Angelia - 

What I found out was that we had some bad data in our db. The reason for the duplicates was that they were really there. It threw me at first because those extra values SHOULDN'T have been there. 

The benefit of this issue is it led us to solve a bigger issue we had under the hood - a result from one of our processes. 

To date - we 've corrected it and applied a new part of the process that will enforce data integrity. 

The only downside is it will take some time for the data to filter out - but otherwise the solution wasn't necessarily Power BI - but PBI allowed us to find and fix it. 🙂

[Thyago_Rezende]

What´s the table from design field?

[heathernicole]

Item table

[Thyago_Rezende]

Can you display the measure and database relationship?

Best regards,

[heathernicole]

@Thyago_Rezende Hey. 🙂 Updated main post with image. Thx!