New column : Exist id between category

[Anonymous]

Hello everybody,

I need your help to add a make a calculate column for my table. 

I have this kind of table, Where I want to add a new column that depend from the "category" and "id":

for each value, of column "id" : check if it's exist as a value on the two category (groupe 1 and groupe 2)

As the example :

• for id1(column id), we find it on the category : groupe 1 and groupe 2 so result  get id1.
• for id2(column id), we not find on the category : groupe 1 so result  get N/A
• for id3(column id), we not find on the category : groupe 2 so result  get N/A
• ....
• for id5(column id), we find it on the category : groupe 1 and groupe 2 so result  get id5
• .....

Table : 

Category	id	New column
groupe1	id1	id1
groupe2	id2	N/A
groupe1	id3	N/A
groupe1	id4	N/A
groupe2	id5	id5
groupe1	id5	id5
groupe2	id6	N/A
groupe2	id1	id1
groupe2	id2	N/A

Thanks you for your help.

Best,

[amitchandak · Accepted solution]

@Anonymous , Try new column like

new column =
var _val = id
return
if(calculate(Distinctcount(Table[Category]),filter(Table,[Id]= _val)) =2, [id], "N/A")

[Anonymous]

Thank you @amitchandak