Issue with values when tables have duplicates

Thanks for your time, im new to power bi so just getting the hang of it. 

I have created the instance below, (ignore the top table)

All the columns in the middle table are created by columns from a database table called (viewform_dbase results) with the exception of the column [Horse] which is taken from a table called (020-RPChelt). The last column [RPR] i have just added from another table called (viewform_dbase vfimport) note the values are all 1513 for Horse 'A Great View'  ie its summing all the values of [RPR] and not indicating the single value and 'Dont Summarize, is selected

The values for [RPR] should read as per the bottom table which I have created from information within the table (viewform_dbase vfimport) All columns are taken from the table (viewform_dbase vfimport) except the column [Horse] which is taken from a table called (020-RPChelt) ie on the 15-01-2017 the value for Horse 'A Great View' is 99. 

I dont want the bottom table, I just want to be able to get the correct value for [RPR] into the centre table, I can then remove the bottom table as [RPR] is the only information I need from it but I need it adding to the middle table.