Forum Discussion

StefRenneboog91's avatar
StefRenneboog91
Regular Visitor
5 years ago
Solved

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 TAB...
Need Help
  • nilimarodrigues's avatar
    nilimarodrigues
    5 years ago

    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's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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