Removing Duplicates in a listing table

[dweaver]

I was trying to create a very simple listing table of a few columns (Brokers name, Sales office, customer). It works however it is displaying duplicate rows of data. Is there a way to do a distinct on a listing table? Or is there a way to remove duplicates? 

[JoeM]

@dweaver - 
Bring all of those columns into the measure tray. Once there, you'll also see the presence of a 'distinct filter' tray. Drag those same column names in again to create your distinct filter.

Note that you may get an error forming the query plan since you don't have a quantitative measure. I'd drag in a measure, take note of the base table in the query plan, remove it, and then set your #ERROR columns to have a base field from that base table that was noted.