How to delete records in a table?

[eddydm]

I'm using a table in Desktop Power BI in which one of the fields (distributionID) sometimes has the value -1. Then this record has not to be included in the calculations. Those records prevents me to relate this table to another table with more information about this distribution.

How can I delete those records (distributionID = -1) in Power BI Desktop.

I can solve this problem in the original data by adapting the sql-view i'm using to import this data, but i like to keep the number of views as low as possible, but I want also to keep the imported data as close as possible to the real data.

I know i can solve the problem by adapting each measure to a calculate instruction where i can add a filter (distributionID <> -1).

Thanks in advance for any suggestion.

[Baskar · Accepted solution]

Hey buddy

I understand your prob like this way,

u have to remove the record which distributionID = -1 correct ? if yes pls follow this stepd

go to Query Editor window, and pick your column(distributionID)  click the downarrow

chose number filter and pick is "Doesnot equal option" from there

and

lets try