add column based on selected value

[Anonymous]

Need help.

Say I have two table 1 and table 2. I am using the Col 1 from Table 1 in a slicer and I have created a measure using SELECTEDVALUE on this column. Say I have selected Value 2.

Now in table 2, I want to add a column (Col 3) which contains 1 or true wherever Col 2 contains this selected value.

Table 1

Col 1

Value 1

Value 2

Value 3

Table 2
Col 1	Col 2	Col 3
TV1	Value 1	0
TV2	Value 2	1
TV3	Value 3	0
TV4	Value 2	1
TV5	Value 1	0

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You could create a measure like this:

Measure = IF(MAX('Table (2)'[Col 2])in VALUES('Table'[Col 1]),1,0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Are you talking about a measure to be placed in a visual or about a calculated column?

If you mean a calculated column, then the answer is simple: you cannot do it. Values in the columns of model tables are always static.

Best
D

[Anonymous]

@Anonymous Can we put a measure in a visual like a table to filter the details. My ultimate goal is that only. This was a workaround I thought of.

In this method, I want to create a column in an existing table (Table 2) based on a selected value from table 1.

[Anonymous]

Yes, that you can do 🙂

Best
D

[bheepatel]

Hi @Anonymous 

Can you try creating the following measure:

Col3 = IF( CONTAINS(Table2, Col2, SELECTEDVALUE(Col1)),  1, 0)

[Anonymous]

@bheepatel it didn't work. all values are coming as zero