Conditions True or False based on the two table

Hi Anonymous ,

According to your statement, I suggest you to try this code to create a measure.

True/False =
VAR _ADD =
    ADDCOLUMNS (
        'Global',
        "True/False",
            IF (
                (
                    'Global'[Pack] = BLANK ()
                        && NOT ( 'Global'[Itemnumber] IN VALUES ( Local[Itemnumber] ) )
                )
                    || ( 'Global'[Pack] = RELATED ( Local[BOMTEXT] ) ),
                "TRUE",
                "FALSE"
            )
    )
RETURN
    MAXX ( _ADD, [True/False] )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.