Merge query adjusting total numbers

[jwittkopp]

I created a merge query in Power BI with left outer and fuzzy matching to perform the merge. The merge matched 21,853 out of 21, 953 records in my data set, this was an accurate number based on null values in my data. After performing the merge, my visualization totals changed from 21,852 to 24, 646. Why did the query merge change my visual totals and how do I correct the merge to reflect the accurate number of 21, 853.

[v-xuding-msft · Accepted solution]

Hi @jwittkopp ,

I think it is cause by enabling fuzzy matching. It will match some similar data with the same value. You could reference the blogs to create a transformation table when use the option to merge table more accurate.

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

Fuzzy Matching 

[v-xuding-msft]

Hi @jwittkopp ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

Best Regards,

Xue Ding

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

[Greg_Deckler]

That's almost impossible to say. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490