How to Check Relationship Accuracy

[bw70316]

I have created some relationships with multiple tables that seems to be working correctly, but I am looking to be able to test **bleep** accuracy. Specifically, I have a sheet with expenses and a sheet with individuals that incurred the expenses. I have added an index column to each and created a one to one relationship. I have take a screenshot and added it below. For Sheet 1 I have the Sex and FY 18 has the costs, they do not overlap in any way aside from the relationship between the indeces that I created. The Screen shot on the bottom highlights the "Female" and "Male" expenses for clothing. How do I ensure these values are accurate aside from the fact the two values are equal to the total from Sheet 1. Frankly, I don't understand how the values are being created from this little information. They are not Avgs, those calculations are the uncircled ones I did via Dax. If more information is necessary, please let me know and thanks in advance for any advice. 

[Chihiro]

If it's one to one relationship, you really have nothing to worry about. Unless you are relating seemingly related column without any actual relationship. But that's bit hard to test.

How is index from one table tied (related in terms of data) to the other? Is it based on dates/time period? Or some other criteria?

[bw70316]

I have a list of individuals for placement where some leave and some enter, but mostly it stays the same. I have compiled all of these into a total sheet called "Sheet 1" (I would rename it but it's already in PBI). I have another sheet with just TOTAL COSTS per expenditure (clothing, education, etc), which is FY 18. These are connected solely through Index columns I created (see first picture). I just don't see how PBI can take things so seemingly incongruent and create a relationship with so little data. 

[Chihiro]

? I'm a bit confused now. So there is no actual relationship between two index columns (i.e. it's not primary and foreign key?).

Then relationship, really does nothing, unless you are trying to filter one table based on selection in the other table vice versa.

Ex: If you use DAX measure to calculate value on one table based on filter applied to the other table etc.

Hard to say what exactly is going on without looking at your model.