How to know if at least one row contains my product

[guil-laume]

Hi everybody,

I have the following problem that i can't solve by myself.

DocumentNumber	Item Family	Contains Family1 or Not
INVOICE1	Family1	Yes
INVOICE1	Family2	Yes
INVOICE2	Family1	Yes
INVOICE3	Family2	No

For a same document number, i have multiple lines. Each lines correspond to an item.
If my item is from the family Family1, if would like to tag in the third column "Yes" for all lines which have the same document number.

Could anyone help me please ? 

[tamerj1 · Accepted solution]

Hi @guil-laume 
Please try

Contains Family1 or Not =
IF (
    "Family1"
        IN CALCULATETABLE (
            VALUES ( TableName[Contains Family1 or Not] ),
            ALLEXCEPT ( TableName, TableName[ocumentNumber] )
        ),
    "Yes",
    "No"
)

[guil-laume]

Thanks @tamerj1 ,

It works !