Forum Discussion

talaespinosa's avatar
talaespinosa
Frequent Visitor
3 years ago
Solved

Differences between two columns from different tables

Hello, I am trying to figure out how can I create a measure that list (and eventually counts its elements) the differences between two columns from different tables where certain filters were applied...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi， talaespinosa 

    It is recommended to use calculated table rather than mesaaure to display the result.

    Please try formula like:
    Calculated Table:

    Result1 = 
 var filter1=SELECTCOLUMNS(FILTER(Table1,<filter1>&&<filter2>....),"column",Table1[Column1])
 var filter2=SELECTCOLUMNS(FILTER(Table2,<filter1>&&<filter2>....),"column",Table2[Column2])
 return  EXCEPT(filter2,filter1)

    Measue:

    Result2 = 
 var a1=COUNT(Result1[column])
 var b1=CALCULATE(DISTINCTCOUNT(Table2[Column2]),FILTER(Table2,<filter1>&&<filter2>))
 return b1-a1&":"&a1

    If it doesn't work, please share a sample file for further research.

    Best Regards,
    Community Support Team _ Eason

lbendlin's avatar
lbendlin
Super User
3 years ago

You are missing 719 from the first table.

 

Pseudo code:

 

UNION(EXCEPT(Table 1, Table 2),EXCEPT(Table 2, Table 1))