Getting difference column in power bi

Question

I want to create difference column using two tables Table 1 and Table 2 , I want to create Table 3 which is having difference of count column using DAX formula

Answer 1

Table3 = 
ADDCOLUMNS(
    DISTINCT(UNION(VALUES(Table1[Product]), VALUES(Table2[Product])) ),
    "@Diff", 
    VAR a = LOOKUPVALUE(Table1[Count], Table1[Product], Table1[Product])
    VAR b = LOOKUPVALUE(Table2[Count], Table2[Product], Table1[Product])
    RETURN a-b
    
    )

Answer 2

Table3 = 
SUMMARIZECOLUMNS(
    Table1[YourKeyColumn],
    "Count_Table1", COUNTROWS(Table1),
    "Count_Table2", CALCULATE(COUNTROWS(Table2))
    "Difference", [Count_Table1] - [Count_Table2]
)