Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

add column based on selected value

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 1Col 2Col 3
TV1Value 10
TV2Value 21
TV3Value 30
TV4Value 21
TV5Value 10

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    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.

6 Replies

  • bheepatel's avatar
    bheepatel
    Resolver IV
    6 years ago

    Hi Anonymous 

     

    Can you try creating the following measure:

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago
        Yes, that you can do 🙂

        Best
        D
  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.