Forum Discussion

yaronklein's avatar
yaronklein
Helper II
4 years ago
Solved

Sort By column provide an error

Hi,

I am trying to do a simple sort by column (sort Issue_Epic_Name by Rank_10011) and I get the following error:

I can gaurentee that the values in Rank_10011 are unique. I even copy them into Excel and checked for duplications and I even created another rank column based on this value plus another unique value and tried to use it with the same error.

I am not sure what I am missing here.
Any advice?

 

Thanks in advance. 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    yaronklein , In a table visual take  Issue_Epic_Name  and count of Rank_10011. Sort count of Rank_10011 desc there should not be any 2. If there are some Issue_Epic_Name   with count =2, then correct those.

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    yaronklein , In a table visual take  Issue_Epic_Name  and count of Rank_10011. Sort count of Rank_10011 desc there should not be any 2. If there are some Issue_Epic_Name   with count =2, then correct those.

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • yaronklein's avatar
    yaronklein
    Helper II
    4 years ago

    Thank you amitchandak, you made me realize that I undersatood it wrong and indeed I had differnt values in Ran_10011 for the same name value of Issue_Epic_name. 
    Now,  this was just part of a bigger problem, however I will open a new issue tomorrow as it is more complex to explain. 
    Thanks for your quick support!
    Yaron