Forum Discussion

Adidas's avatar
Adidas
Icon for Helper I rankHelper I
5 years ago
Solved

Retrieve values from another unrelated table

Hi all,  I have two tables Table1 & unrelated Table2 a common 'ID' column exists in both tables  The only use of table2 is for a slicer built over it. I need to calculate a new column in Table1 c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Adidas ,

     

    Check the formula.

    Measure = IF(NOT(ISFILTERED('Table (2)'[Id])),FALSE(),IF(SELECTEDVALUE('Table'[Id]) in VALUES('Table (2)'[Id]),TRUE(),FALSE()))

    Result would be shown as below.

     

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Adidas , Try a measure like

Match = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[id] = max(Table1[ID]) )) //better to put row context using values

 

a new column like

Match = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[id] = (Table1[ID]) ))

 

Refer how to copy values from one table to another table as column -https://www.youtube.com/watch?v=czNHt7UXIe8

  • Adidas's avatar
    Adidas
    Icon for Helper I rankHelper I
    5 years ago

    Thanks, amitchandak ,

    unfortunately, both suggestions for measure and column didn't work for me,

    still, it ignores the slicer's selections