Negative filters data

[marioxp]

Hi,
I have the following data model, I need to reject data from the [action] column, one [id_kth] can have several [actions. How can I delete selected records [share]?

[v-jiascu-msft]

Hi @marioxp,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[dilumd]

Hi @marioxp

I'm sorry! your question is not very clear to me; can you explain it with an example please?

[marioxp]

hi @dilumd

Below is an example of a client who participated in Action 3 but did not participate in Action 2 - I have to reject them. According to the attached data, I should only be the first customer.

I want to show to clients who should take part in action 2, that is still not participating in them.

I think I explained the situation.

[dilumd]

Hi @marioxp

According to the way I understood, if you don’t have “Action 2” inside your column you need to reject them.

Use below.

Action 2 = IFERROR(IF(SEARCH("Action 2",Actions[Action],1,BLANK()),"Pass","Reject"),"")