if function 3 conditions from different table

[YoussefN]

Hi,

I have two tables REFERENCE and CALL I want to add a conditional column to the table CALL with True and False based on three conditions. 2 of the conditions are in table CALLand 1 in TABLE REFERENCE.

The conditions are If the value of the field Nr. of work = 1 and the value of the field Nr of order = 1 and the field reference point in table REFERENCE = 70 then the value should be true and else FALSE

How can I do this?

Thanx in advance

example table

[v-shex-msft]

HI @YoussefN,

You can try to use below measure:

result =
VAR _no =
    MAX ( tableCall[Order No.] )
VAR _work =
    MAX ( tableCall[Nr. of work] )
VAR _order =
    MAX ( tableCall[Nr of order] )
VAR related_point =
    LOOKUPVALUE ( TableReference[Reference point], TableReference[Oder No.], _no )
        + 0
RETURN
    IF ( related_point = 70 && _work = 1 && _order = 1, TRUE (), FALSE () )

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Have a look at the LOOKUPVALUE function or RELATED or RELATEDTABLE.