Forum Discussion

RaMa87's avatar
RaMa87
Copper Contributor
Jul 23, 2021

Custom Filter function

Hi guys,

 

I am looking for a custom filter function

 

A112
A212
A312
A112
A412
A112
A212
A212

 

I have sth similar to above table already in Power BI. What I am now looking for is a filter that searches the first column (combination of text and numbers) and removes all lines which are listed less than 2 times. SO in the above example I would need to get rid of the following lines:

 

A112
A212
A312
A112
A412
A112
A212
A212

 

It might be very easy but I can't think of a smart solution at the moment. Does anyone have an idea how to do this?

 

Thanks and cheers

 

BI & Data Analysis
excel
power bi

5 Replies

  • RaMa87's avatar
    RaMa87
    Copper Contributor
    Jul 23, 2021
    Problem solved
    I changed strategy and simply removed individual lines which was easy with the "Keep Rows" --> "Keep Duplicates" function
    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Jul 23, 2021
      I am pleased that you have come to a solution yourself.
      Please visit the forum again soon, there is always someone happy to respond to your reply.

      I wish you continued success with Excel.

      NikolinoDE
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 23, 2021

    RaMa87 

    If I understand the translation correctly, look for a way to keep duplicates and delete individual entries.

    If so, here is an example with VBA in the inserted file.

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    • RaMa87's avatar
      RaMa87
      Copper Contributor
      Jul 23, 2021
      Hi Nikolino,

      thanks for the answer - in retrospective my wording was maybe not correct. I want to keep all lines which are listed more than 2 times, i.e. delete all entries with only one or two lines. So keep everything =>3 and delete the others --> so the problem is that I do not simply need to delete individual entries.
      The filter would also need to be within Power BI (i.e. the query I set up) otherwise it will make the whole automated output useless.
      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Jul 23, 2021
        Regarding Power BI, unfortunately I can't help you. My knowledge in this area is very limited.
        Maybe, one of the specialists here who are very familiar with Power BI could help you.

        I wish you continued success with Excel

        Thank you for your understanding and patience

        Nikolino
        I know I don't know anything (Socrates)

Resources