Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I am trying to write a complex filter in Power BI Power Query, but it seems to not understand the logic with parentheses. How should it be done correctly?
To make it more fun, let's say I want to filter out from my basket all green fruit except for cucumbers (which has seeds, so biologically it's a fruit) , i.e. I want to keep all fruit that is not green, plus cucumbers.
I write:
#"Filtered Rows1" = Table.SelectRows(#"Previous step", each [color] <> "green" and ( [color] = "green" and [type] = "cucumber" ) )
I get an empty table as a result. What am I doing wrong?
Solved! Go to Solution.
#"Filtered Rows1" = Table.SelectRows(#"Previous step", each [color] <> "green" or [type] = "cucumber" ) )
#"Filtered Rows1" = Table.SelectRows(#"Previous step", each [color] <> "green" or [type] = "cucumber" ) )
1st condition says it should not be "Green" & 2nd condition should be "Green" & "Cucumber".
once you mention <>Green, it excludes all green.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
42 | |
30 | |
27 | |
27 |