Issues sorting one column by another when using filters

Hi,

Very new to PBI so the solution here, may be very basic. For reference, I'm using a Direct Connection to a local SQL db. 

I have a table which is something like the following:

Primary Key -  ReportLayoutID - Row Number - Title

0                  -  3245                  -  1                    - Sales

1                  -  3245                  -  2                    - Marketing

2                  -  3245                  -  3                    - IT

3                  -  3248                  -  1                    - Whatever

4                  -  3248                  -  2                    - Not important

5                  -  3248                  -  3                    - Etc

So, my report is concerned with the first 3 rows. I want to display tabular data (in a table or matrix) and show the "Title" column.

However, that column must be sorted by the row number. 

Now when I try to do that, I'm advised "There can't be more that one value in "Row Number" for the sane value in "Title". Please chose a different column for sorting on or update data in "Row Number". 

That makes sense, as the number sequencing does start again in that column as you can see. So I went to "Edit Queries" and applied a filter on the ReportLayoutID column, to only show those with an ID of "3245". I've manually checked the remaining rows and there's no duplicates after the filter was applied. Yet, when trying to sort by the Row Number field, I STILL get the same message!

What am I missing?