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 table...
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.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity 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 ()
    )