Error while comparing data from 2 tables

Hello GilbertQ & v-chuncz-msft,

Apologize for the delayed response, I was trying out your suggestions -

GilbertQ your suggestion to append the two tables and then compare the data worked.

I tried the other suggestions but they didn't work -

1. Change the cross filter direction on the relationships - FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?

2. Try to drag "Area" field from table Sites.

p.s. i also noticed the "Site" column of FY17 table had few extra entries that wasn't in "Site" column of FY18 table; corrceted this but the issue still persisted.

I used the "Combine" options from the PowerBI Desktop App (Query Editor) to append the two tables.

Once i combined the 2 tables and created 1 table there was no relationship to manage so everything became easy.

Thank you both for your suggestions.

/rgds