Sorting Data through Power Query Editor

[nikostou]

Hi

I have a very big table that I have Imported from a SQL Database. I would like to filter the data on a specific column; "Company", so that I will only import rows that are from Company 1.

I have tried the filter function, but I see that my calculated table, which is using data from this big table, and that I have based my report on is still calculating across companies. I have also tried putting on a report filter in the Power BI report, but it still calculates across all companies.

I would like to filter the data already at the import since my amount of data is very large.

I hope you can help me!

Thank you in advance.

[ImkeF]

Make sure to apply the filter in the query editor and not in DAX.

I've you've done that and still get errors, please paste M-code or screenshots of what you've done.

[nikostou]

I have made the filter in the Query Editor, but as you see in the table the calculated table still finds companies 1 to 5. I the Query Editor I filtered on only Company 1.

The DAX string you see in the picture is the string I wrote to make the table. After this I added multiple calculated columns to it.

I have also tried to redo the table, but that did not help either.

Thank you for your help!

[ImkeF]

How about the source-table "FM_Mutation". Does is have the the companies as well? Have you refreshed it?

[nikostou · Accepted solution]

I tried refreshing all of my tables, that did not work.

Then I tried removing the filter and applying it again, that worked!

I have no idea why it worked, but I can live with that 

@ImkeF  Thank you for your time and your help!