Forum Discussion
admin11
Memorable Member
Memorable MemberRank expression for CUSTOMER NAME get error ?
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 :-
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/
2 Replies
- VahidDM
Super User
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/
