Forum Discussion

-ThomasHermann's avatar
-ThomasHermann
New Member
2 years ago

Filter based on a value in another column

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

 

 

Need Help

3 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    2 years ago
    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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

     

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

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