I am doing a very simple query and I get the above error. There are three tables with matching keys. What I am doing is seeing if the 'Functional Area' column is a certain value, then go and lookup the table that corresponds to that column, depending on the value.
If ([Functional Area]="Agreements", LOOKUPVALUE(agreements[PL Issues], agreements[WorkRequestID], [ID]), "false")
I have managed to do the LOOKUPVALUE fine on its own without the IF statement, which works without the error: = LOOKUPVALUE(agreements[PL Issues], agreements[WorkRequestID], [ID]), However, that does not meet requirements as I need to check other tables too. I would rather code this properly than insert unique code in 6 different columns.
But upon using the IF, then this error appears: Calculation error in column 'WR': A table of multiple values was supplied where a single value was expected.