title: Average Of Column Counting Duplicates Once - PowerPivot + DAX
body: <p>I have a column in PowerPivot that I would like to get the average of. However I only want the rows included that are the only instance of a value or the first instance of a duplicate value in another column. Is this Possible with DAX? </p>
  
  <p>Simply put I need the column average of unique rows, determining uniqueness from another column.</p>