Return 'Yes' or 'No'/BLANK if value exists in related table

[Kristofferaabo]

Hi,

I have two tables connected via 'project code'.

"Table A" and "Table B" (connected via project code)

I have made a simple table in my canvas with columns only from 'Table A'. Can I somehow make a calculated formula returning a Yes or a blank if the project code also appear in table B?

Thanks

Kristoffer

Project code:   date              sales       In table B?

Project 1          17Jun             4546         Yes

Project 2          24Jan            34646         Blank

[brunozanoelo]

i have the same issue BUT I need to return one value from the WORKING table if DAX can´t find one value in the related table.

YesNoIfFoundInOtherTable =

IF(

ISBLANK(

LOOKUPVALUE('Related Table'[Key], 'Related Table'[Key], WorkingTable[Key])

),

WorkingTable[DESCRIPTION], 'Related Table'[DESCRIPTION]

)

How it is possible?

[FayeB1901]

Hi @Phil_Seamark - This works great as a measure. But ideally I this to function as a column. I'm trying to create a matrix like this (where values represent revenue split within a category). Your measure is the apparatus/no apparatus piece - where I'm checking to see if the  unique identifier in Table A, is in Table B. I need to show this as column critera, not in values.

How can I edit the measure to apply as a column? 

Cheers, Faye

[nkrowitz]

Howdy, this solution worked for me:

YesNoIfFoundInOtherTable =

IF(

ISBLANK(

LOOKUPVALUE('Related Table'[Key], 'Related Table'[Key], WorkingTable[Key])

),

"No", "Yes"

)

[Phil_Seamark · Accepted solution]

HI @Kristofferaabo

You could try the following calculated measure.

In table B? = 
VAR MyProjectCode = MIN('Table A'[Project Code])
RETURN IF(
        COUNTX(
            FILTER(
                'Table B',
                'Table B'[Product Code] = MyProjectCode
                ),
                'Table B'[Product Code])>0,
                "Yes"
                )

[angelarojasmora]

This solution worked perfectly for me. Thanks! 

[Anonymous]

This is brilliant. Thanks @Phil_Seamark  for the solution and @Kristofferaabo  for asking the question. 

[Kristofferaabo]

Works great! exactly! thanks so much