Forum Discussion
Helper IRetrieve 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 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:
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
4 Replies
- amitchandak
Super User
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
AdidasThanks, amitchandak ,
unfortunately, both suggestions for measure and column didn't work for me,
still, it ignores the slicer's selections
- littlemojopuppy
Community Champion
You can simulate a relationship between two unrelated tables by using the TREATAS() function
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
