Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditions True or False based on the two table

 

I have a two table one table Global Another one Local .  Both table have common value Itemnumber , based on  

 

Global Table :

 

Itemnumber      Pack 

101                  

102                 

103                   NewHL

104                   NewPack 

 

 

 

Local Table :

 

Itemnumber     BOMTEXT 

101                  

102                   CH

103                   

104                   NewPack 

 

 

Based on the item i am trying  to get true or false result 

 

Global Pack                       

Local (BOM text)                                                              

Output Result

Blank

Blank / Item code is missing in local input file

TRUE

Blank

Value

FALSE

Value

Blank / Item code is missing in local input file

FALSE

Value

Value

TRUE

 

 

Expect Output:

 

Itemnumber      Pack              BOMTEXT             true/false

101                                                                        TRUE

102                                             CH                      FALSE

103                   NewHL                                         FALSE

104                   NewPack         NewPck                TRUE

 

 

Looking for support.  thanks in advance..

Help appreciated
Help me
Help me please
Help required
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    I created a demo for you, I think this might be help.

     

    Column = IF((RELATED(GlobalTable[Pack])=blank() && LocalTable[Pack]=Blank()) ||(RELATED(GlobalTable[Pack])<>blank() && LocalTable[Pack]<>Blank()),TRUE,FALSE)

     

     

    If the answer helps please accept the solution ğŸ™‚

     

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 

    if the tables are connected with a relationship, then you can use 

    True/False =

    SELECTEDVALUE ( Local[Pack] ) = SELECTEDVALUE ( Global[Pack] )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 
    Please refer to attached sample file

    True/False = 
IF (
    NOT ISEMPTY ( Local ),
    IF ( 
        SELECTEDVALUE ( Local[Pack] ) = SELECTEDVALUE ( 'Global'[Pack] ),
        "True",
        "False"
    )
)