Forum Discussion
Solved
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 'U...
Hi, below are the measures I created for Master,
aaa = LOOKUPVALUE(customer_table[Text],customer_table[UCR], SELECTEDVALUE(master_table[UCR]),customer_table[Name], "aaa")bbb = LOOKUPVALUE(customer_table[Text],customer_table[UCR], SUM(master_table[UCR]),customer_table[Name], "bbb")ccc = LOOKUPVALUE(customer_table[Text],customer_table[UCR], SELECTEDVALUE(master_table[UCR]),customer_table[Name], "ccc")Remember to select this to also display empty rows.
Hi Ahmetyilmaz, thank you for your assistant, this has worked.