Beginner level - Check if value is in table

[StefRenneboog91]

Hey all, First of all, thanks a lot already for the one who is willing to help me. Let me describe the situation : I have TABLE 1 with COLUMN 1 = PERNR I want to create a measure where I check if TABLE1.PERNR in TABLE2 COLUMN PERNR.

If value in TABLE1.PERNR not in TABLE2.PERNR the measure should be 1 , else 0.

I hope someone can help me out 🙂

Thanks a lot already!

KR,

Stef

[nilimarodrigues · Accepted solution]

Hi,

If you have one to one relationship between Table1 and Table 2, you could create a calculated column on Table1 with formula:

If(PERNR = Related(Table2.PERNR),"1","0")

Hope this helps.

[mahoneypat]

Assuming you have no relationship between the two tables, you can use this measure expression in a table visual with your Table1[PERNR] column

IsThere =
VAR thispernr =
    MIN ( Table1[PERNR] )
RETURN
    IF (
        ISBLANK (
            CALCULATE (
                COUNT ( Table2[PERNR] ),
                Table2[PERNR] = thispernr
            )
        ),
        1,
        0
    )

Regards,

Pat