Forum Discussion
One-to-Many Relationship with Unique Values Not Working
Normally for these type of issues, i recommend using the Column distribution, quality and profile features from the View menu in Power Query but if there are 100,00+ values it will be of limited use!
Column quality might help though. And Column Distribution will give you a summary of how many unique values you have (should be the same as the row count)
You can also solve these issues with DAX. Create a COUNT measure on part number.
Drag it to a table, drag part number as well. Then order the table by the measure (highest to lowest).
All values are supposed to be 1 so look for non-1 values
Tried that. Column Quality & Distribution shows 1000 distinct, 1000 unique, 100% valid, 0% error, 0% Empty. Ofcourse, I've 100,000+ part numbers so it's not that useful.
OK try the DAX, it should be quite quick to do.
Additionally, when using profiling and quality, the default is to sample 1000 rows. The whole dataset can be sampled by clicking on 'column profiling based on top 1000 rows' at the bottom of the power query screen. The other option is shown '...based on entire dataset' . Warning : it may take a long time
