0

i have 2 tables: enter image description here

I would like to see how many values table one exists in table two and how many aren't exist in table tow so the result should be for example 5 exit and 10 not exist

  • Please try to describe your problem clearly with examples of underlying data, expected and actual results. Right now, I really don't understand the problem. – W.B. Feb 25 '21 at 09:20
  • sorry, I re-wrote the post. I hope it will help! –  Feb 25 '21 at 09:37
  • You can Join tables using the key column. Then you can count all rows with Value and NULL to get your expected output. – mkRabbani Feb 25 '21 at 10:07
  • is there another way like using DAX: Number of Table2 rows = CALCULATE( COUNTROWS(Table2), FILTER( Table2, Table2[Column1] = Table1[Column1] ) ) –  Feb 25 '21 at 10:12

0 Answers0