Removing Duplicated to create a relationship!!!

You did both Capitalize and Trim? OK, we're going to have to hunt this down by hand. Load your query and go into the report editor. Write a measure (with whatever names you called things, obviously):

Duplicate Hunter = COUNTA(SalaryTable[JobTitle])

Now add a table visual with SalaryTable[JobTitle] and the measure [Duplicate Hunter]. That should give you something that looks like:

Job Title                                    Duplicate Hunter

Underwater Basket Weaver       1

Executive Assistant Barista        1

Sarcasm Translator                   1

...

Somewhere in that list there's either a pair of titles with a 2, or one title with a 3. Go to filters and set it to Duplicate Hunter is greater than 1. Whatever is left are the duplicates. Hopefully seeing what it is will give you a clue as to how to fix it. If not...uh...we can talk about that when it happens.

Anonymous That is a great idea . . . going to hijack this particular reply and ask if you can help me solve my many to many issue: http://community.powerbi.com/t5/Desktop/Is-this-Possible-DAX-many-to-many/m-p/37128#U37128

kcantor after an hour of thinking about your question I started to smell burning circuitry so I'm going to give my brain a break. But if you could send me your sample data maybe I can do better with something concrete.

keyahorm I'm dying of suspense. What's the word? Did that help you track down the culprit?

This seems to be a common problem for me, I wonder Microsoft choose not to display the non duplicates?

The error "One of the columns must have unique value" is particularly frustrating, especially after you have chosen 'Remove Duplicates' on both columns. I understand there may be technical reasons for this - but from a usage point of view. The error is useless - the computer may as well just beep loudly, would give you same information as the error!

If this is still open, I have found removing duplicates in a workskheet in the source file (usually excel) is easier. Then you can load the table to creat the relationship in Power BI.