Add Custom Column with condutions of dublicate value

[EserB]

Hello, 

My Data has the columns named "Issue ID" and "Brand". I want to add column to data named " Brand Overlapping" for the conditions below:

1-) If a Issue ID has both of Brand A and Brand B then Brand Overlapping = A & B Together

2-) If a Issue ID has only Brand A  then Brand Overlapping = Only A

3-) If a Issue ID has only Brand B  then Brand Overlapping = Only B

How can I add this column? 

Appricate if you help for this issue 😞

Issue Id	Brand	Brand Overlapping
1	A	A & B Together
1	C	A & B Together
1	B	A & B Together
2	A	Only A
2	A	Only A
3	B	Only B
3	C	Only B
4	A	A & B Together
4	B	A & B Together

[EserB]

Hi, 

It works perfectly. I'm appreciate very much. Thank you 🙏

[ThxAlot]

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Brand Overlapping CC =
VAR _issue = Data[Issue Id]
VAR _t =
    FILTER ( Data, Data[Issue Id] = _issue )
RETURN
    SWITCH (
        TRUE (),
        COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1
            && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) )
                = BLANK (), "Only A",
        COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) )
            = BLANK ()
            && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "Only B",
        COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1
            && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "A & B Together"
    )