Excel PQDM cannot able to create relationship of Non Duplicate data of same excel

[newexcler]

Hi Experts,

I have a table with about 250 rows and 5 columns.
I am trying to create DM to make some pivot charts and filters
So I used the fact table and created 5 references and retained each column & removed all duplicates and Blank rows
and create a relationship diagram.
I have Issues with "Role code Description" column after removing duplicates, I have about 170 rows and but when I map this only query to the fact table, I get error that I have duplicates and it cannot create many to many relationship, misleading as this column is a new query by removing other columns and removing duplicates and blanks
Debugging Analysis
1. Data type is same "text" for both new query and Fact Table information
2. No Duplicates
3. No Blank Data
4. Verified in excel by copying the column and removing duplicates

Please can you share with me tips to resolve this issue ?
Thanks a ton

 

[newexcler]

I split the data into two and It is now allowing me to create relationships. But pivot fails, when I add these two into the filter, only one is accepted.
Any Ideas how to resolve this issue. I am doing a workaround to create multiple pivot tables.