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

group the records and Rank Defect ID by TCs Blocked, get the max rank for each Defect ID in a new column, now if the rank is > 2 that will be the duplicate Defect ID make it as 'Y', if its not greater than 2 then thats not duplicate.
some thing like this

 

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

    Hi MPMP,

    I tried with RANK.EQ and also using RANKX, and got some results, but not sure how you did suggest the entire DAX, please could you share details?.Thanks.