Help with selectcolums / relatedtable / filter
I've read for a while now but keep going around in circles to what seems a simple problem and probably is, so sorry for my simple mind not working. Master Table with unique customer referrence 'UCR' column (and a few others but not important maybe) Customer Table with unique customer referrence UCR , NAME, Text (3 Columns only) Customer Table many to one relationship with Master Table. In the Master Table I want to add a column from Customer Table where the UCR match, filtered to display data from the Text Column only if the Name matches a specific text that I can select. So I tried : 'aaa' = FILTER(RELATEDTABLE(Customer Table),Customer Table[NAME] = aaa) But get error.... multiple columns .... scalar vaule
