Forum Discussion
Filter not working in Query editor, any help
Anonymous Thank you for response, Yes they are more 10,000 rows and Please can you point me to links or way to filter the row for a particular test? can I put in SQL commands in advanced editor?
Hi acerNZ ,
To use Advanced Editor for filtering, Apply Filter on the required column and then in the right in the Applied Steps section click on Filtered Rows step as below-
And then open Advanced Editor where you can filter your desired data, here is how(Highlighted is the column at whch you want the filter)-
Please mark my post as Soulution if it helps you.
Anonymous Based on some youtube, I could get the DAX filtter ( add table) and was able to put a filter in the Data view (Modelling), however I am not seeing this table in "Query Editor" when I load the tables in transform.