topic Re: Add Custom Column with condutions of dublicate value in DAX Commands and Tips

Add Custom Column with condutions of dublicate value

EserB — Sun, 21 Jan 2024 01:17:12 GMT

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

Re: Add Custom Column with condutions of dublicate value

Jihwan_Kim — Sun, 21 Jan 2024 05:23:24 GMT

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" )

Re: Add Custom Column with condutions of dublicate value

ThxAlot — Sun, 21 Jan 2024 06:15:32 GMT

Re: Add Custom Column with condutions of dublicate value

EserB — Sun, 21 Jan 2024 07:23:09 GMT

Hi,

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