Custom Filter function

[RaMa87]

Hi guys,

I am looking for a custom filter function

A1	1	2
A2	1	2
A3	1	2
A1	1	2
A4	1	2
A1	1	2
A2	1	2
A2	1	2

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:

A1	1	2
A2	1	2
A3	1	2
A1	1	2
A4	1	2
A1	1	2
A2	1	2
A2	1	2

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

[#2]

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

[#3]

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.

[#4]

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)

[#5]

Problem solved
I changed strategy and simply removed individual lines which was easy with the "Keep Rows" --> "Keep Duplicates" function

[#6]

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