I'm new to Power Pivot/DAX and I'm trying to find a match from one column in Table 1 in another table, Table 2, and if a match is found, take another field from Table 2 and then try to find a match from that field to another Table, Table 3, and then return corresponding values from Table 3 back to Table 1. If a match isn't found between Table 1 and Table 2, I want to be able to iterate to yet another Table, Table 4 and do the same thing - if a match is found in Table 4, then try to find a match with Table 3 and return corresponding values back to Table 1. I have relationships built between these tables in the data model, but it's not working. It looks like it only works if a match is found between Table 1 and Table 2. If a match isn't found between Table 1 and Table 2, I can't get it to iterate to the next step. Hope that makes sense. I've tried using the CALCULATE function and USERELATIONSHIP within the CALCULATE function but can't get it to work. Any help or guidance would be appreciated.
