Forum Discussion

thmonte's avatar
thmonte
Helper IV
8 years ago

Comparing columns from two different tables that have relationships and show differences only

So I am looking for some assistance creating a discrepancy report.  I have two databases that should always be in sync with each other and I am going to be using PowerBI to spot check this.  The data...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
8 years ago

please clarify: you state & display a visual where both A1 & B1 are together already.  

 

so you do have the 2 tables joined it appears

 

if this is the case you can create a measure 

Different Flag = if (A1 <> B1, 1, 0)

 

this measure should work in the same visual, putting a 1 where they differ.  One could then apply a page level filter of just 1s for this field/column

 

 

 

 

  • thmonte's avatar
    thmonte
    Helper IV
    8 years ago

    Thats a pretty interesting solution and it might work.  I was able to get it all in the same visual by creating relationships between the two tables using reference data.  How can I create the measure to pull in the value across two seperate tables?

  • thmonte's avatar
    thmonte
    Helper IV
    8 years ago

    CahabaData I'm having a hard time getting the proper formula to work

     

    VAR __BASELINE_VALUE = COUNTA(table1[A1])
VAR __VALUE_TO_COMPARE = COUNTA(table2[B1])
RETURN
	IF(__BASELINE_VALUE <> __VALUE_TO_COMPARE,"T","F")

    This is what I tried but it is not returning the right results.  It looks like its adding the numbers.