Cthulhu
Why Cthulhu? Because the mental gymnastics required to figure this out nearly drove me insane. And because the exact reason you would need this measure is probably beyond the comprehension of mere mo...
I think I found a cleaner approach:
Local Group Index =
VAR _CurrIndex = MAX ( Cthulhu[Index] )
VAR _CurrGroup = MAX ( Cthulhu[Animal] )
VAR _LocalGroupStart =
CALCULATE (
MAX ( Cthulhu[Index] ),
ALLSELECTED ( Cthulhu ),
Cthulhu[Index] < _CurrIndex,
Cthulhu[Animal] <> _CurrGroup
)
VAR _LocalIndex = _CurrIndex - _LocalGroupStart
RETURN
_LocalIndex
I'll have to give them a try. The more modern version of Cthulhu can be found inside of Streaks! Streaks! - Microsoft Fabric Community
I've got a simplification for that problem now too. 🙂