Remove rows based on column condition without using power query

[Anonymous]

Hello, 

I am trying to delete rows from a DAX created table in Power BI based on a certain condition. I cannot use Power Query, like explained here . The filter options in the 'Data'  tab in Power BI Desktop are not sufficient because they do not remove the data. My goal is to create and 1:Many relationship and that cannot occur whenever I have duplicates, even though I've filtered them out. 

I am looking for a DAX query that deletes all rows that contains a value higher than 1 in a specific column. What would be the correct DAX syntax to achieve this?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may just add FILTER.