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
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.
 
 
MPMP's avatar
MPMP
Frequent Visitor
5 years ago

You need to create another column and get the MaxRank in each group, if the max rank = 0 then 'N' if the max rank =1 then 'Y'

  • MPMP's avatar
    MPMP
    Frequent Visitor
    5 years ago

    Hi Luis,

    I hope my solution helped you to achieve what you were looking for, could you please accept it as solution ?

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

      Hi, I am still trying to figure out gow to apply your suggestion.