cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
el_dido Frequent Visitor
Frequent Visitor

Fill column content with value from a filter

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".

 

powerbi_forum.png

Any suggestion is more than welcome, thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
AClerk New Contributor
New Contributor

Re: Fill column content with value from a filter

Hi @el_dido 

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],"")

Email.gif

Good Luck!
A

2 REPLIES 2
AClerk New Contributor
New Contributor

Re: Fill column content with value from a filter

Hi @el_dido 

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],"")

Email.gif

Good Luck!
A

el_dido Frequent Visitor
Frequent Visitor

Re: Fill column content with value from a filter

many thanks @AClerk , it's working!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 245 members 2,976 guests
Please welcome our newest community members: