Rank expression for CUSTOMER NAME get error ?

[admin11]

Hi All

I have create a expression :-

rank = RANKX('summrizeTable2','summrizeTable2'[sum],,ASC)

I get error msg :-

Column '' in Table '' contains a duplicate value '3' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

Can some one share with me where go wrong ?

I also created another expression similar :-

rank = RANKX('summrizeTable1','summrizeTable1'[sum],,DESC)

I don't get any error msg :-

My PBI sample file 

https://www.dropbox.com/s/0we2yrwbxpcn9xn/dynamic%20diamension%20Small%20file%20size%20ver012.pbix?d...

Paul 

[VahidDM · Accepted solution]

Hi @admin11 

Change the relationship between summrizeTable2 and summrizeTable1 to the many to many and it will work then.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

This issue trouble last few day , today i learn some thing new. thank you