Distinct Count Inflating Total

[DemandMGR]

I am currently building out a huge app for my company with multiple tabs and I am running into an issue with one visual. The source data I am using involves UPCs and all the other product information. In the visual I have the values from 3 different sources of UPC data using distinct count to count the total number of SKUs. The problem is the distinct count on one of the sources is inflating the total number. I have done the same thing to all 3 soruces and 2 of them work perfectly while I am running into this issues with the 3rd one. I am wondering if anyone has run into this issue before. There are no measures being used to calculate. If someone has advice on a measure that I can write to add to the visual that would be great. This build is important it will save so many hours a week for my team and it has potential to be oushed out to the entire company once I am copmplete with it. So tis is very important. I am a PowerBI amateur so the fact I am almost done with this is amazing. I am just ironing out some details.

Thank you in advance for the help!!

[v-rzhou-msft]

Hi @DemandMGR 

Could you share a sample file with me by your Onedrive for Business and show me the result you want?

This will make it easier for me to understand your requirement.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.