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!
Go to Solution.
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],"")
many thanks @AClerk , it's working!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!