Issues with a relationship created

[nmck86]

Hi,

I have created a relationship in my data set where the tax id information from mutliple data sources are set on a cross directional relationship. I am running up against issues though when the tax id number isnt in the data set it sums up all the information from all payment amounts that have a blank tax id number... For instance, I funded $10,000 to Sally Corp in 2016 and that $10,000 shows up correctly. However, I didnt fund anything to Nancy Corp so it sums up all payments were the tax id is blank or not present into a large $1,000,000 payment (which is the representation all payments where we didnt fund a specific organizaiton previously). Anyone ever ran into this issue?

I hope this makes sense.

[v-qiuyu-msft]

Hi @nmck86,

Can you share sample data about those tables which has relationship between? Which common field dis you use to create the relationship?

Best Regards,
Qiuyun Yu

[nmck86 · Accepted solution]

Thanks for the assistance! I figured it out. It was because my relationships are setup by a different criteria and it was pulling in the amount. I think for now the answer is to remove that field or create a duplicate of the data set and create new relationships to pull in this one field.

[vanessafvg]

@nmck86  what are you expecting it to rollup into  if the id is blank?  

[nmck86]

$0

[vanessafvg]

@nmck86 so what do you want to do with the data that doesn't have an id and has a value?   hide it?  

is it possible to provide screen shots?

[nmck86]

I wouldnt mind if it was just blank as some of the other ones are... I am attaching the info to this reply. You will notice that the correct amounts of $2,000 and 7,500 are there; however, there is this large amount of $17mi which is completely inaccurate. @vanessafvg

[vanessafvg]

@nmck86 Can you post of screen shot of your relationship view and also the code for your measure for payment amount