Compare dataset with standard and get missing records

[Anonymous]

Dear all,

I'm trying to compare a database (containing products sold to customers) with a standard of selling at each customer. I want to get all the products that were not sold to each customer: Database (minus) Standard. The relationship between the tables is Database (m) and Standard (1).

Thank you for your help

Daniel

[amitchandak]

@Anonymous , You want to create a new tbale

Use this kind of formula A -B (in A not in B )

except(distinct(client1[Client]) ,distinct(client2[Client]) ) 

But  if you need this as measure, you need have common client table and use this measure with common client table

countrows(except(distinct(client1[Client]) ,distinct(client2[Client]) ) )

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19