Check if a value is in another table which are not related

[PBI_Monkey]

Hi Community,

I have 2 unrelated tables.

A slicer with Company has to be selected and then it returns the X values associated with it.

Table1 contains X Coordinates eg:

Company	X
A	144.617
A	144.623
A	144.616

Table 2, contains the same but different company and values:

Company	GeoX
A1	144.888
A2	144.837
A2	144.623

I would like to create a calculation which flags if a GeoX value is found in Table1.

For example, if GeoX is found in Table1 in the X column it should return a true or 1. 

Remember that these tables are never related and the Company in Table1 will always be filtered with a slicer to give the list of X Values to do the check.

I've tried a number of options using LOOKUPVALUE but it always returns True or 1.

Any ideas would be awesome!

Thanks

[PC2790]

Hi @PBI_Monkey ,

Did you try this:

IsPresent = if(ISBLANK(LOOKUPVALUE(Table1[X],Table1[X],Table2[GeoX])),0,1)

It is working for me.

Thanks 

[PBI_Monkey]

Hi PC2790,

Thanks for the quick response.

I have already tried your suggested calculation, but it returns incorrect True or False.

I think because it needs to be done after the Slicer is filtered and not at the Data side.

As the Slicer values needs to be selected first and then the Match is done.