topic Re: Conditions True or False based on the two table in DAX Commands and Tips

Conditions True or False based on the two table

Anonymous — Mon, 02 Jan 2023 16:56:45 GMT

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..

Re: Conditions True or False based on the two table

Anonymous — Mon, 02 Jan 2023 17:02:28 GMT

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 🙂

Re: Conditions True or False based on the two table

tamerj1 — Mon, 02 Jan 2023 17:21:56 GMT

Hi Anonymous

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

True/False =

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

Re: Conditions True or False based on the two table

Anonymous — Tue, 03 Jan 2023 07:22:26 GMT

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.

Re: Conditions True or False based on the two table

tamerj1 — Tue, 03 Jan 2023 08:06:30 GMT

Hi Anonymous
Please refer to attached sample file

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