title: DAX query to exclude records from dataset
body: <p>I have to write a query to exclude records using DAX. Now I am not sure how would I exclude records based on a particular condition.</p>
  
  <p>For example, I have to filter data and display employee data for a company in all states except New York. How would I achieve that?</p>
  
  <p>It seems like I can only apply a filter to just display specific data and not for exclusion as you would do in SQL. In SQL we can just use a <code>NOT IN (...)</code> clause to do that. Is there something similar in DAX?</p>
  
  <p>Any help would be greatly appreciated. Thanks!!</p>