Compare values in table

Question

Hi expert,&nbsp;Here is what I am trying to do. I want to compare the value of column 'Synced to BRPrint' in Table 'Reportxx' and the value of column&nbsp;'Sync from Reportxx' in Table 'BRPrintxx'. I was thinking about creating a measure but I have no clue how to write the DAX yet. Can someone help on this? Really appreciate it.&nbsp;

phil_seamark · Answer

Hi&nbsp;ChenChristyYu
&nbsp;
If the country column is unqiue in both tables, you can create relationship between the two tables using the Country column
&nbsp;
Then in one of the tables you can add a calculated colum that uses logic to compare the two.
&nbsp;
The calculation below is one you might add to Table1.
&nbsp;
Difference Column = 
    RELATED('Table2'[Value]) - 'Table1'[Value]
I have a simple PBIX file here that shows the technique
&nbsp;
https://1drv.ms/u/s!AtDlC2rep7a-oxHf9-K0gats1V2x

phil_seamark · Answer

Hi&nbsp;ChenChristyYu
&nbsp;
When you say you want to compare?&nbsp; What do you mean by that?

chenchristyyu · Answer

I mean if the number equal to each other.

chenchristyyu · Answer

If the value does not match then I want to point out the difference on my dashboard, I thought about highlighting the value that does not match, but it does not seem like PowerBI has the function. Or I can create a measure and print out"'value A' and 'Value B' do not match"

phil_seamark · Answer

So in the top line "Australia", the value in the highlighted columns match?&nbsp; Whereas for the 2nd row "Austria" the columns don't match.
&nbsp;
Is the country code unique in both tables?&nbsp; Or can "Austrialia" be on more than one row in either table?

Forum Discussion

Compare values in table

10 Replies

Related content

Table Sort , sort order , comparer

Comparing values between different tables

Compare value in two tables

Compare 2 Tables

Comparing Values between tables