Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

Rank 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 allow...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

VahidDM 

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