Exclude sales based on info in another related table

[Tob_P]

Hi,

I'd like to exclude sales (amount) based on a related field (SellToCustomerNo). So if the SellToCustomerNo is listed in the other table, how can sales from these be excluded?

Thank you

[tamerj1 · Accepted solution]

Hi @Tob_P 
If the other table is not related then you can try something like

=
CALCULATE (
    [Sales Amount],
    FILTER (
        Sales,
        NOT ( Sales[SellToCustomerNo] IN VALUES ( TableName[Customer No.] ) )
    )
)