Custom Filter function

Occasional Contributor

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

 

5 Replies

@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.

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.
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)
Problem solved
I changed strategy and simply removed individual lines which was easy with the "Keep Rows" --> "Keep Duplicates" function
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