Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort by another column issue - already sorted?

Hi,    I want to sort a list of 100 codes in the following way:  Select 10 codes and sort them alphabetically first. And after these sort the rest of the codes alphabetically below.    I created...
Need Help
  • QuinnP's avatar
    QuinnP
    6 years ago

    Hi Lenerius

     

    I just came across the same error!

     

    For me the issue was that I was using DAX to definine a column (call it A) using another DAX defined column (call it B). Because A is sorted by itself by default, and A is defined by B, asking to sort B by A results in a circular reference. To fix this I redefined my DAX so that both A and B were sorted by an original table column, then everything worked fine!

     

    Hope that helps!


    Quinn

QuinnP's avatar
QuinnP
Advocate II
6 years ago

Hi Lenerius

 

I just came across the same error!

 

For me the issue was that I was using DAX to definine a column (call it A) using another DAX defined column (call it B). Because A is sorted by itself by default, and A is defined by B, asking to sort B by A results in a circular reference. To fix this I redefined my DAX so that both A and B were sorted by an original table column, then everything worked fine!

 

Hope that helps!


Quinn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    QuinnPThanks! That ended up being my solution as well! Thanks for sharing!