Forum Discussion
How to Check Relationship Accuracy
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.
? 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.