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.
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.