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]?

 

 

 

 

4 Replies

  • dilumd's avatar
    dilumd
    Impactful Individual
    8 years ago

    Hi marioxp

     

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

     

    • 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"),"")
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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