Removing duplicated data or over-counting values

How to remove duplicate data or over-counting values from cross-database join?

Let say we have two data-sources one is Orders and second is Target.
                       
                                                                                             Orders                                       Target

If we join two data sources based on name we will get this type of data.

 Name          Sales            Target
--------         --------           ---------
John             7010             30,000
Tom              2750             18,000

While joining M-1 relationship target data source showing over counting of target values.

Here Actual Target sales for John is 10,000 but it is showing 30,000

To Overcome this type of problems we need to follow three solutions:

Solution 1:

Change the aggregation either MIN or AVG to remove over-counting.

Solution 2:

Create a calculated field that removes the duplicate values:

Sum ([Target]) / COUNT ([Name])

Solution 3:

Use a Fixed expression to remove the duplicate data.

{ Fixed [Name] : MIN([Target]) }

If you crack the challenge send me the workbook to this mail id: 

skrafi449@gmail.com