Query to subtract column from different Table

[MightyRabbit]

Dear all, 

Could you please kindly help with the querry to subtract 1 column from another table.
I have "table 1" with Column "No" Like the one below:

No

A1

A2

A1

A2

A3

A4

A5

I have "Table 2" with Column "No_deleted" as following:

No_deleted

A1

A4

How can I subtract Column "No" from table 1 to column "No_deleted" in table 2, and putting the result like following:

No	Result
A1	0
A2	A2
A1	0
A2	A2
A3	A3
A4	0
A5	A5

Thank you very much for your help.
Best regards,

[MightyRabbit]

Hi @rubayatyasmin ;

That works perfectly. Thanks 🙂

[rubayatyasmin · Accepted solution]

Hi, @MightyRabbit 

try to use calculate and all with IF and NOT DAX func

the code will be something like

Result = 
    CALCULATE(
        IF(
            NOT(CONTAINS(table2, table2[No_deleted], table1[No])),
            table1[No],
            "0"
        ),
        ALL(table2)
    )