Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi, I encountered this query in the advance query editor.
#"Filtered Rows" = Table.SelectRows(#"Converted to Table", each true)
I have no clue what "each true" means and it is taking 20 lines from my table.
Thanks
Hi @Anonymous,
In my test, above query returned the same rows as that returned by its previous step. Usually, we add a filter condition which returns bloon values "True/False" after "each" function. But "each true" mean it is always "True", in other words, there is no filter, so, it would return all data rows without filtering.
In your scenario, please check the result of previous step #"Converted to Table". It should also return 20 lines.
Regards,
Yuliana Gu
"
Thanks for the reply. There are no boolean values in my data and it is still taking off 20 rows of data. That is was I was curious.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 54 | |
| 42 | |
| 30 | |
| 24 |