Hi, below are two threads which shed some light on similar cases as well:
Personally, I find myself using this formula mostly, adding the Row ID column in advance:
Filter(thisTable,Group=thisRow.Group).[Row ID].Find([Row ID])
When you use multiple filters you can get the same results for nested subgroups:
Filter(thisTable,Group=thisRow.Group).Filter(Subgroup=thisRow.Subgroup).[Row ID].Find([Row ID])
3 Likes