How do I compare measures of different tables?

[Muskan1]

I am trying to test whether 2 tables have the same values or not. 

I have ProductId and Revenue in both tables(A,B) and would like to compare sum(Revenue) for each ProductId. I want to create a table in front end with ProductId, sum(Revenue) for TableA ,  sum(Revenue) TableB and  difference between them. How do I do this?

[Mark_Little]

If you have the model built it is pretty simple,

Add ProductID as you dimension, Then  three measures, Sum(RevenueTableA), SUM(RevenueTableB), Sum(RevenueTableA) - SUM(RevenueTableB).

This will be dependent on your data model and field names. The do need to be linked on the ProductID and the revenue field need unique names.

[Muskan1]

I tried to qualify the fields. But then I get the total sum(RevenueTableB) instead of sum per ProductID