Forum Discussion

coachbart's avatar
coachbart
Frequent Visitor
5 years ago
Solved

Error Sort by another column | can't find it

Hello,

 

I can't find the problem. I get an error

 

This is my pibx file .

 

I have 1 querie / sheet called RGS schema original with the error.

Splitted this table in four separate tables (Balans, Rapport, Rubriek and Grootboek). I can use the sort by column button on 3 of the 4 tables (Balans, Rapport, and Grootboek). So the problem is Rubriek. (this is in RGS original all level 3 rows)

 

I looked for duplicates but I cant find them. I don't know how to go furter so I hope you can help me fix this.

 

Thnx in advance

 

Bart

Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Create a measure to COUNT the sortering value.   Put it in a table with Omschrijving.

     

    Order it by the measure and you'll find the duplicates.

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    Create a measure to COUNT the sortering value.   Put it in a table with Omschrijving.

     

    Order it by the measure and you'll find the duplicates.

    • coachbart's avatar
      coachbart
      Frequent Visitor
      5 years ago

      Thnx,

      used calculated column. Find some duplicates 😞

       

      DuplicateFlag =
      IF (
      COUNTROWS ( FILTER ( _originalRGS; _originalRGS[Omschrijving] = EARLIER ( _originalRGS[Omschrijving] ) ) )
      > 1;
      1;
      BLANK ()
      )