Forum Discussion

marioxp's avatar
marioxp
Frequent Visitor
8 years ago

Negative filters data

  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]?        
marioxp's avatar
marioxp
Frequent Visitor
8 years ago

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's avatar
dilumd
Impactful Individual
8 years ago

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