I have two tables: Table 1 (let's call it "Bank") has a code number for each registered bank and its name (it comes from our database); Table 2 (let's call it "Plan") has a code number for each bank and a link to its logo image in google drive (it comes from an Excel file).
All codes in Plan are in Bank, but not all codes in Bank exist in Plan.
I need to create a calculated column in Plan that checks if the selected value in Bank exists in Plan. If it exists, then the column shows the corresponding link. If not, then it shows a specific link.
I am using the Simple Image visual to show the image, so the link column is marked as Image URL. This visual only accepts a column as value.
I have tried this dax expression:
SELECTEDVALUE(Bank[Code]) IN Plan;
but I am getting an error saying that "function CONTAINSROW must have a value for each column in the table expression.