DAX Help

Hi Anonymous 

Here is my solution. Might be other/better/nicer ones.

1. Upload only the relevant data into your table(s). i.e. Table1 will include only Item=A and ID=2; Table2 will include only Item=B and ID=1.

I achieved this in the query editor by adding steps to filter the columns.

As mentioned above, I have 2 tables and not 1.

2. Create 2 custom columns

Equal Test Var = IF(T1[Test Var] = RELATED(T2[Test Var]),1,0)

This ^ is to mark the identical columns by Test_Var.

Difference = IF(T1[Test Var] = RELATED(T2[Test Var]),RELATED(T2[Results]) - T1[Results],-990)

This ^ is to calculate the substruct between the results values.

After applying the filters (Equal Test Var=1), this is what I got:

Thanks!
A