Forum Discussion
Beginner level - Check if value is in table
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
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.
2 Replies
- mahoneypat
Microsoft Employee
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
nilimarodriguesHelper III
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.
