Forum Discussion

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
5 years ago

how to group rows with calculated columns

Hi, I have a table with calculated columns  as you see in the attached picture, I am trying to group in same row for example Defect ID 32013, 32026, 32053, etc where as a result the column #TCs Bloc...
Need Help
MPMP's avatar
MPMP
Frequent Visitor
5 years ago

Can share your DAX maesure for RANKX and comparision ? let me take a look at it and see where you are going wrong

 

  • luis_pflucker's avatar
    luis_pflucker
    Icon for Helper II rankHelper II
    5 years ago

    I tried with:

    Column = RANKx(all('All Defects (2)'[Defect number]),'All Defects (2)'[ATRKBlockedCOL])
     
    Where Defect number = Defect ID and ATRKBlockedCOL is #TCs Blocked
    • MPMP's avatar
      MPMP
      Frequent Visitor
      5 years ago
      Try using the below dax measure:


      RANKX(
      FILTER(
      'Table Name',
      'Table Name'[Column Name1] = EARLIER('Table Name'[Column Name1]) 
      ),
      'Table Name'[Column Name2],,DESC,Dense
      )

      The above measure will group your records and assigns rank inside the group
      • luis_pflucker's avatar
        luis_pflucker
        Icon for Helper II rankHelper II
        5 years ago

        Hi, you mean: 

        Column = RANKx(filter('All Defects (2)','All Defects (2)'[Defect number]= earlier ('All Defects (2)'[Defect number])),'All Defects (2)'[ATRKBlockedCOL],,DESC,dense).
        See attached what I got.