check if value contains in another table through measure

[Anonymous]

Hi everybody, 

I have two tables (CurrentTable and HistoryTable) which are linked through myID. I want to display all elements form CurrentTable not contained in my filtered HistoryTable. 

I tried to use the proposed solution here, but the proposed solution through a custom column does not work for me because I want the result to depend on the applied filter. 

I think my problem could be solved through a measure. Unfortunately, I am still having trouble to understand the row context in measures. I am therefor a little lost and really apreciate your help.

How do I create a measure that returns true if myID is contained in historyTable and false if it isn't? 

Thank you for your help in advance and please let me know if you miss any information.

[johnt75 · Accepted solution]

Is In History = IF ( ISEMPTY( RELATEDTABLE(HistoryTable) ), 0, 1 )

This is assuming that you have a 1-to-many relationship from CurrentTable to HistoryTable. You can put the columns you need from CurrentTable into a table visual and apply a filter to only show items where [Is In History] is 1. ( true / false values don't work when using a measure as a filter, you need to use numbers ).

[Anonymous]

That worked beautifully! Thank you very much!