Filter based on a value in another column

[-ThomasHermann]

Hello,

I have a table with different values and a column in which the same values are per group.

If now the target which has an x is completed, all others of the same group including the completed rows should be filtered out.

Example: The last three rows have an x and are completed. If a row with an X is completed, all rows with the same value should also be filtered.

Is this possible?

I'm really at the end of my knowledge 😞

Kind regards
Thomas

[AlienSx]

hello, @-ThomasHermann filter your table (Col_J = "x" and Col_O = "completed"), extract those IDs and filter your original table once again by Col_P. Smth like this

	completed = List.Buffer(
		List.Distinct(
			Table.SelectRows(
				your_table,
				each [Col_J] = "x" and [Col_O] = "completed"
			)[Col_P]
		)
	),
	filter = Table.SelectRows(
		your_table,
		each List.Contains(completed, [Col_P])
	)

[Anonymous]

Hi @-ThomasHermann ,

What is the expected output of the above sample? You may also simulate the output in Excel and post screenshots.
Suggest copying the table content directly and posting it to help other users engage with the issue more quickly.
How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[ronrsnfld]

1. Table.Group by whatever your identifying column(s) are.
2. create an aggregation to return nothing if all the entries are marked completed.
3. Re-expand the table.