Fill column content with value from a filter

[Anonymous]

Hello,

From the example below, I want to fill column "Email Subject Line" with the value that is selected from the filter "Subject Line Template".

In another words, if for example I select "Subject BB" from the filter, all the records from column "Email Subject Line" will be filled with "Subject BB".

Any suggestion is more than welcome, thanks!

[Anonymous · Accepted solution]

Hi @Anonymous 

You can create a measure in your main table that will use your subjects table.

T6 is my subjects table.

M_Subject = SELECTEDVALUE(T6[Subject],"")

Good Luck!
A

[Anonymous]

many thanks @Anonymous , it's working!