Retrieve values from another unrelated table

[Adidas]

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 called 'Match' that should have the value "True"
only if the same ID was selected in the slicer.

obviously, I can't use the RELATED function because the tables have no relationship,

Tried that with no success:

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

There is no effect by the chosen values by the slicer

[Anonymous · Accepted solution]

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

[littlemojopuppy]

You can simulate a relationship between two unrelated tables by using the TREATAS() function

Propagating filters using TREATAS in DAX - SQLBI

[amitchandak]

@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]

Thanks, @amitchandak ,

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

still, it ignores the slicer's selections